Re: Adding a variable to oracle that contains quotation marks??
| From: | Rick Emery | Date: | Tue, 21 Jan 2003 12:56:51 +0000 |
| Subject: | Re: Adding a variable to oracle that contains quotation marks?? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-132394@lists.php.net to get a copy of this message | ||
$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