|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[1999-11-28 11:55 UTC] kara at cvs dot php dot net
[1999-11-29 09:31 UTC] havardpe at fast dot no
[2002-06-16 08:40 UTC] sander@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Nov 02 05:00:01 2025 UTC |
Here is the code segment that gives me problems: (simplified) $conn_id = odbc_connect($db_name, $user, $pass); $stmt = odbc_prepare($conn_id, "INSERT INTO table (value1, value2) VALUES (?, ?)"); $data = array('test1', 'test2'); odbc_execute($stmt, &$data); When using an Oracle database server, this produces the following error message: Warning: SQL error: [Oracle][ODBC Oracle Driver]SQLBindParameter has not been called for parameter #2., SQL state 07001 in SQLExecute in ... I tried to use Access first, and got the same error (07001). I cannot find any other ways to bind my parameters than to rely on the odbc_execute function to to this. NOTE: if I insert the SQL parameter values directly into the SQL statement it works fine, but I need to pass them separate from the query to avoid quoting problems.