How to query this record

SkyHigh · Dec 3, 2002

Hi

I have a record where value is Uj"\n"KL the field type as you can guess is varchar, when I query this record by this value i.e.

SELECT * FROM my_table WHERE trid='Uj"\n"KL' it does not return anything while this record exists, can any one please help me there.

Thanks for your help
Brenda

rycamor · Dec 4, 2002

Are you trying this query from the psql command line, or insinde a programming environment such as PHP. If you are using the query inside a programming environment, it's possible that the "\n" is being interpreted as a line break, instead of the literal text.

YOu might have to escape the double-quotes and double-escape the newline character:

Code:

SELECT * FROM my_table WHERE trid='Uj\&quot;\\n\&quot;KL'

-------------------------------------------

Big Brother: "War is Peace" -- Big Business: "Suspicion is Trust"
(

http://www.cl.cam.ac.uk/~rja14/tcpa-faq.html)

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

How to query this record

SkyHigh

Technical User

rycamor

Programmer

Similar threads

Part and Inventory Search

Sponsor