[sqr-users] Single quote issue

["abhay sachar" <sachar_abhay@hotmail.com>]

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