Re: display query results - Mailing list pgsql-php

From PJ
Subject Re: display query results
Date
Msg-id 48932C6E.9030309@videotron.ca
Whole thread Raw
In response to Re: display query results  (PJ <af.gourmet@videotron.ca>)
List 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")


pgsql-php by date:

Previous
From: PJ
Date:
Subject: Re: display query results
Next
From: "David Calle"
Date:
Subject: Procedimientos con parametros