| From: | PJ <af(dot)gourmet(at)videotron(dot)ca> |
|---|---|
| To: | Andy Shellam <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk> |
| Cc: | pgsql-php(at)postgresql(dot)org |
| Subject: | Re: display query results |
| Date: | 2008-08-01 15:31:58 |
| Message-ID: | 48932C6E.9030309@videotron.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
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")
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Calle | 2008-08-07 17:16:12 | Procedimientos con parametros |
| Previous Message | PJ | 2008-07-31 20:32:47 | Re: display query results |