Re: [PHP] Problems inserting single quote into Oracle database

2001-10-31 Thread Kevin Dewsnup
D]>; <[EMAIL PROTECTED]> Sent: Tuesday, October 30, 2001 5:57 PM Subject: Re: [PHP] Problems inserting single quote into Oracle database > On Wed, 31 Oct 2001 11:01, Kevin Dewsnup wrote: > > I am having problems with inserting single quote's > > into an oracle 8.1.

Re: [PHP] Problems inserting single quote into Oracle database

2001-10-30 Thread Thies C. Arntzen
le 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,

Re: [PHP] Problems inserting single quote into Oracle database

2001-10-30 Thread Hugh Danaher
;[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. &

Re: [PHP] Problems inserting single quote into Oracle database

2001-10-30 Thread David Robley
On Wed, 31 Oct 2001 11:01, Kevin Dewsnup wrote: > 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 i

[PHP] Problems inserting single quote into Oracle database

2001-10-30 Thread Kevin Dewsnup
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