[PHP] Adding a variable to oracle that contains quotation marks??

Hi All, I'm trying to add a variable to an oracle database but it fails due to the fact that it contains quotation marks. These have to be present for the end user. My Script is as follows: === if ($conn == true) {

Re: [PHP] Adding a variable to oracle that contains quotation marks??

$query = UPDATE ACTIVITY SET COMMENTS = \'$updatecomments\' WHERE ACTIVITY_ID =\'$actcode\'; - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 6:53 AM Subject: [PHP] Adding a variable to oracle that contains quotation marks?? Hi All,

Re: [PHP] Adding a variable to oracle that contains quotation marks??

Once you use double quota mark the character BackSlash doesn't need anymore that's my experience ^_^ - Original Message - From: Rick Emery [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 8:56 PM Subject: Re: [PHP] Adding a variable to oracle that

RE: [PHP] Adding a variable to oracle that contains quotation marks??

Thanks Rick Henry, but I am still unable to add single quotation marks '. When I added the \' to the variable as given below (thanks again Rick) I get the following error when trying to add anything, regardless of ': Warning: Ora_Parse failed (ORA-00911: invalid character -- while processing OCI