Adding a variable to oracle that contains quotation marks??
| From: | Rea_David at emc dot com | Date: | Tue, 21 Jan 2003 12:53:49 +0000 |
| Subject: | Adding a variable to oracle that contains quotation marks?? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-132393@lists.php.net to get a copy of this message | ||
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