: [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
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
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
, 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
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
5 matches
Mail list logo