RE: [sqr-users] Single quote issue

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

Yes, I am aware of that. But that is for the query.

But how about in SQR - I am assuming I would have to do a find and replace 
within the string. So is it that I would have to create a function that does 
that and use that function to change that run control param in the SQR?

Thanks,
Abhay

>From: "Alexander, Steve" <Steven.Alexander@sanjoseca.gov>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "'This list is for discussion about the SQR database 
>reportinglanguagefrom Hyperion Solutions.'" <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] Single quote issue
>Date: Fri, 28 Oct 2005 17:03:42 -0700
>
>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



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