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

2001-10-31 Thread Kevin Dewsnup
: [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.7 database through a form. When inserting 'its' it works fine. When inserting 'it's' I get this error

[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

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 in

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

2001-10-30 Thread Hugh Danaher
, 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

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

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