PDO PostgreSQL cannot insert multiple commands into a pre...
Posted: Fri Mar 05, 2010 8:45 am
I developed application on Windows/Apache/PHP 5.2/PostgreSQL 8.3. It is all working.
I moved my application to hosting CentOS/Apache/PHP 5.2/PostgreSQL 8.3 and get error with PDO PostgreSQL.
Statements like
generate error: cannot insert multiple commands into a prepared statement
This error occups when I try to prepare command:
Has everyone has this error?
On my machine I have libpq version 8.2.3, but on hosting 8.1.11. Is this important?
Thanks for help.
I moved my application to hosting CentOS/Apache/PHP 5.2/PostgreSQL 8.3 and get error with PDO PostgreSQL.
Statements like
Code: Select all
update table set value=1 where id=1;
update table set value=2 where id=2;This error occups when I try to prepare command:
Code: Select all
$connection = new PDO('pgsql:host=localhost;dbname=databases', $user, $password);
$statement = $connection->prepare('update table set value=1 where id=1;update table set value=2 where id=2');
$result = $statement->execute($params); On my machine I have libpq version 8.2.3, but on hosting 8.1.11. Is this important?
Thanks for help.