RE: [sqr-users] Single quote issue

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

You have to replace the single quote with two single quotes.

-----Original Message-----
From: abhay sachar [mailto:sachar_abhay@hotmail.com] 
Sent: Friday, October 28, 2005 4:35 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Single quote issue

Hi,

I was wondering if anyone knows how to work with data that is being passed 
to an SQR through a run-control page and that data has a (') - single quote 
in it, which could be anywhere , for example - St Martin's Court

What is the way to handle this kind of data, because when it builds the 
query - it bombs out with the error - ORA-01756: quoted string not properly 
terminated

Any help is greatly appreciated.

Thanks,
Abhay



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users