note 36557 added to function.ociexecute
| From: | egypt at nmt dot edu | Date: | Tue, 14 Oct 2003 23:31:48 +0000 |
| Subject: | note 36557 added to function.ociexecute | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-58592@lists.php.net to get a copy of this message | ||
Whereas MySQL doesn't care what kind of quotes are around a LIKE clause, ociexecute gives the
error:
ociexecute(): OCIStmtExecute: ORA-00904: "NM": invalid identifier
for the following.
<?php
$sql = "SELECT * FROM addresses "
. "WHERE state LIKE \"NM\""; // error!
$stmt = ociparse($conn, $sql);
ociexecute($stmt);
?>
it's fine if you just use single quotes:
. "WHERE state LIKE 'NM'";
but i think it's interesting that ociparse doesn't say anything
----
Manual Page -- http://www.php.net/manual/en/function.ociexecute.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+36557
Delete -- http://master.php.net/manage/user-notes.php?action=delete+36557&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+36557&report=yes
Search -- http://master.php.net/manage/user-notes.php