$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,
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
