#13008 [Opn->Fbk]: Multiple update/inserts fail

ID: 13008 Updated by: sniper@php.net Reported By: Brian_Teravskis@Cargill.com -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: Linux 2.2.12-20 Red Hat 6.1 PHP Version: 4.0.6 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2002-10-30 08:04:46] Brian_Teravskis@Cargill.com I'm trying to recreate the problem, but unfortunately I no longer have the system that I originally had the problem on. I only have available an HP-UX 11.0 system and a Mandrake 8.2 system, and I'm having all kinds of problems building PHP on the HP-UX system. I have just about got it built except for some GD shared library problems. Based upon Chris's last report the problem still exists. Hopefully I will be able to test again by the end of the week. ------------------------------------------------------------------------ [2002-10-30 03:59:13] loeffler@medi-bench.de Im am using Windows NT and PHP 4.2.3 and experience the same problems with MS SQL Server 2000: i try to do multiple inserts in one query: <script> $sql = " INSERT INTO tbl (col1, col2) VALUES( $int1, '$str1'); INSERT INTO tbl (col1, col2) VALUES( $int2, '$str2'); ..." mssql_query($sql); </script> the thing is: one query with more than one insert works, the data is is in the DB. But all others fail. It also works if I do only one insert at the time. Even it works, if I put all inserts in one string and do 10000 inserts with one query. I see a problem here, because the amount of data can grow very large. so there are probably some restrictions to the contents of a string-Variable and the String-Length of a query. I dont understand, why it is not possible to do a second query after inserting more then one lines... chris ------------------------------------------------------------------------ [2002-10-25 01:00:06] php-bugs@lists.php.net No feedback was provided for this bug for over 2 weeks, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2002-10-09 11:59:14] iliaa@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip If the problem still occures try upgrading to freetds-0.53 and seeing if that'll solve the problem. ------------------------------------------------------------------------ [2002-08-26 15:38:39] Brian_Teravskis@Cargill.com I will check within the next week or two to verify. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/13008 -- Edit this bug report at http://bugs.php.net/?id=13008&edit=1