pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PJ <af.gourmet@videotron.ca>
To: Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
Cc: pgsql-php@postgresql.org
Subject: Re: display query results
Date: Fri, 01 Aug 2008 11:31:58 -0400
Message-ID: <48932C6E.9030309@videotron.ca> (raw)
In-Reply-To: <4891C439.6000106@videotron.ca>
References: <48909454.7040305@videotron.ca>
	<82E74D266CB9B44390D3CCE44A781ED90B64DC@POSTOFFICE.cranel.local>
	<4890A871.3020906@videotron.ca>
	<4890AA8C.9080907@spidersilk.net>
	<4890CA07.2040405@videotron.ca>
	<4890D124.7020506@mailnetwork.co.uk>
	<4890D6F6.40709@videotron.ca>
	<4890DBBC.6080404@mailnetwork.co.uk>
	<4890E12F.4050805@videotron.ca>
	<4890E297.3080405@mailnetwork.co.uk>
	<4891C439.6000106@videotron.ca>

You were quite right, the problem was a line feed after the word "Alcohol"
Now it works fine.
Thanks, I learned a lot .... :)

Andy Shellam wrote:
>> Haha, no worries, I've had the same issue before.
>> It's almost certain that the text in your column does not exactly 
>> match "Alcohol" for one of a few reasons, e.g.
>>
>> "Alcohol " (right-padding)
>> " Alcohol" (left-padding)
>> " Alcohol " (padded both sides)
>>
>> will not match = 'Alcohol' in the query.
>> Try trimming the data in that field - from PgAdmin or some other 
>> query tool, run something like:
>>
>> |UPDATE glossary_item SET "name" = |trim(both ' ' from "name")




view thread (21+ messages)

Message-ID: <48932C6E.9030309@videotron.ca>
Permalink:  ../48932C6E.9030309@videotron.ca/
Also on:    postgresql.org/message-id/48932C6E.9030309@videotron.ca

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: af.gourmet@videotron.ca, andy.shellam-lists@mailnetwork.co.uk
  Subject: Re: display query results
  In-Reply-To: <48932C6E.9030309@videotron.ca>
  References: <48909454.7040305@videotron.ca> <82E74D266CB9B44390D3CCE44A781ED90B64DC@POSTOFFICE.cranel.local> <4890A871.3020906@videotron.ca> <4890AA8C.9080907@spidersilk.net> <4890CA07.2040405@videotron.ca> <4890D124.7020506@mailnetwork.co.uk> <4890D6F6.40709@videotron.ca> <4890DBBC.6080404@mailnetwork.co.uk> <4890E12F.4050805@videotron.ca> <4890E297.3080405@mailnetwork.co.uk> <4891C439.6000106@videotron.ca> <48932C6E.9030309@videotron.ca>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox