On Tue, Oct 30, 2001 at 09:54:19PM -0800, Hugh Danaher wrote:
> I don't know if this will work for Oracle but try putting a backslash before
> the single quote mark (e.g. it\'s) the ' should then taken as another
> character by php.
> Hope this works for you.
single quotes are escaped using another single quote in
oracle:
$var = "it''s";
will do the job.
tc
> Hugh
> ----- Original Message -----
> From: Kevin Dewsnup <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, October 30, 2001 4:31 PM
> Subject: [PHP] Problems inserting single quote into Oracle database
>
>
> > I am having problems with inserting single quote's
> > into an oracle 8.1.7 database through a form.
> >
> > When inserting 'its' it works fine.
> >
> > When inserting 'it's' I get this error:
> > "OCIParse: ORA-01756: quoted string not properly
> > terminated in blah..."
> >
> > So then I try 'it''s' (which works in SQL*Plus) I get
> > this error:
> > "OCIStmtExecute: ORA-00911: invalid character in
> > blah..."
> >
> > Thank's in advance!
> >
> > -Kevin
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Make a great connection at Yahoo! Personals.
> > http://personals.yahoo.com
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
