|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2006-07-30 10:08 UTC] tony2001@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Oct 26 23:00:02 2025 UTC |
Description: ------------ Running Firebird 2.0RC3 on Win2003 server w/Apache 2.2.2, I get this easily reproduceable error. I seems that ibase_query() now binds the '?' character in some erroneous way. Reproduce code: --------------- Table DDL: - - - - - - - - - - - - - - - - - - - - - CREATE TABLE "File"( "Name" Varchar(252) NOT NULL, "Type" Smallint NOT NULL, PRIMARY KEY ("Name") ); INSERT INTO "File" ("Name", "Type") VALUES ("This is a filename", 321 ); - - - - - - - - - - - - - - - - - - - - - $dbh = ibase_pconnect(); // arguments set in php.ini ibase_query($dbh, 'SELECT "Name" FROM "File" WHERE "Type" = ?', 321); Returns: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 1 321 ) Expected result: ---------------- I expected to see the same result as running: ibase_query($dbh, 'SELECT "Name" FROM "File" WHERE "Type" = 321' ); -which returns the correct recordset without hiccups.