From:             [EMAIL PROTECTED]
Operating system: Linux 2.2.12-20 Red Hat 6.1
PHP version:      4.0.6
PHP Bug Type:     MSSQL related
Bug description:  Multiple update/inserts fail

I'm using FreeTDS 0.51 to access an MSSQL 7.0 pl1 database server. I can
use PHP to SELECT information from the database with no problems. I'm
having problems with multiple insert/updates done to the database in

My algorithm attempts to insert/update several rows of data into the
database after an HTTP put. It will first attempt to do an SQL insert, and
if that errors due to duplicate key restraints it will do an SQL update.

I'm finding that it will do the first update, but after that nothing
appears to work unless I close the connection to the database and reopen it
again. While this works in a small installation, I can see problems with
hundreds of database updates per minute constantly opening and closing
connections for each row updated.

I can do multiple SQL inserts in sequence with no problems. It is when the
key restraint warning occurs and I do an update.

I have the code if interested.

Here is my PHP configure line:

./configure --with-mysql --with apxs=/usr/local/apache/bin/apxs --with-gd
--with-mssql=/usr/local/freetds --with-sybase=/usr/local/freetds

Edit bug report at:

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to