Re: 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" <remery@emeryloftus.com> To: <Rea_David@emc.com>; <php-general@lists.php.net> Sent: Tuesday, January 21, 2003 8:56 PM Subject: Re: [PHP] Adding a variable to oracle that contains quotation marks?? > $query = "UPDATE ACTIVITY SET COMMENTS = \'$updatecomments\' WHERE ACTIVITY_ID =\'$actcode\'"; > > ----- Original Message ----- > From: <Rea_David@emc.com> > To: <php-general@lists.php.net> > Sent: Tuesday, January 21, 2003 6:53 AM > Subject: [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) > { > > $query = "UPDATE ACTIVITY > SET COMMENTS = '$updatecomments' WHERE ACTIVITY_ID = > '$actcode'"; > $cursor = Ora_Open ($conn); > $result = Ora_Parse ($cursor, $query); > $result = Ora_Exec ($cursor); > > ora_close($cursor); > Ora_Logoff($conn); > } > =========================================================== > > Can anyone tell me what to do! > > Thank you > Dave > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php