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 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
Backslash works for mysql. Have a look at the addslashes (for putting into Oracle) and stripslashes (for displaying data retrieved) functions, also the magic_quotes settings in your php.ini. -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA My lucky color just faded. -- 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]
