Question 1:
When using PEAR DB, are you supposed to be able to use a prepared statement
multiple times? I would suppose yes, but when I execute the code below,
the second use of the prepared statement results in an error:
$stmt = $conn->prepare ("INSERT INTO abc (i, c) VALUES (?, ?)");
if (DB::isError ($stmt))
die ("prepare() failed: " . $stmt->getMessage () . "\n");
$result = $conn->execute ($stmt, array (4, "d"));
if (DB::isError ($result))
die ("execute() failed: " . $result->getMessage () . "\n");
$result = $conn->execute ($stmt, array (5, "e"));
if (DB::isError ($result))
die ("execute() 2 failed: " . $result->getMessage () . "\n");
The error message from the script is:
execute() 2 failed: DB Error: syntax error
I'm using MySQL. The queries that show up in the MySQL log file are:
23304 Query INSERT INTO abc (i, c) VALUES ('4', 'd')
23304 Query Object
Looks to me like $stmt is being munged?
Question 2:
How to you bind a NULL value to a placeholder? In DBI, you use undef
to stick a NULL into a query; in PEAR DB, I tried both null and an unset
variable, with the result that an empty string was placed into the query
string in both cases.
--
Paul DuBois, [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
