note 36557 added to function.ociexecute

From: 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

« previous php.notes (#58592) next »