PEAR:DB mysql and mssql

From: Date: Tue, 16 Dec 2003 14:44:17 +0000
Subject: PEAR:DB mysql and mssql
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-9577@lists.php.net to get a copy of this message
Hi all I have a problem with updates on my mssql server. I use this code to update a row (bauer_id is PK) $sth = $db->autoPrepare($CT_BAUER, $table_fields, DB_AUTOQUERY_UPDATE, 'bauer_id = 1' ); $db->execute($sth, $table_values); I work with ms sql server in production and mysql on my workstation (who wants to have an sql server on his ws? :) On mysql everything works fine. But on the sql server no rows were updatet (but no error occours). If I tried it without the where clausel like this: $sth = $db->autoPrepare($CT_BAUER, $table_fields, DB_AUTOQUERY_UPDATE); $db->execute($sth, $table_values); everything works (generally all the rows were updated and thats not verry usefully). Another hint, if I use the autoexecute statement, an error will occour on mssql, on mysql no problem. I also tried to execute an normal update like this update bauer set bezeichnung = 'abc' where bauer_id = 1 in a sql front end and it worked. No problems with inserts and deletes on mssql and mysql. Thanks Marco

« previous php.pear.general (#9577) next »