Re: Usage of double quotes

<guru.bhai.rules_at_gmail.com> wrote in message news:403784fb-d7c8-4a05-8f4a-c9c625b2d05b_at_h18g2000yqj.googlegroups.com...
> Hi All,
> I have an insert statement that is embedded in a PHP code. It
> basically inserts a JS string. We have lots of single quotes inside
> the string which we replace by double single quotes. It works fine,
> but strangely now, the dev team wants to enclose the whole string in
> double quotes. Is there a way of enclosing the entire string in double
> quotes? I know Oracle doesn't permit using the same.
>
>
> This is a part of the string -
>
> )+6;pVM=pVF.substring(y,pVF.indexOf(".",y));}}
> else if (window.ActiveXObject && window.execScript){
> window.execScript('on error resume next\npVM=2\ndo\npVM=pVM+1\
>
> Thanks in advance
> Guru
>

use bind variables and then you won't care how the string is quoted. (also you won't be subject to sql injection, you application will preform better and scale better)
Jim Received on Fri Jul 03 2009 - 10:46:40 CDT