PHP 4.0 Bug #8022 Updated: mssql_query seems to be fail with sql statement "set"

ID: 8022 User Update by: lingc@mail.nsysu.edu.tw Status: Closed Bug Type: MSSQL related Description: mssql_query seems to be fail with sql statement "set" There is some supplement about this problem. May be described sql-statement is not a good example, so it will confuse the point. There are several SQL-command instead of the original select query (select news from table),and these SQL command may be closed by transaction because the query are related. And the for loop is used for several indep. operations, so set option can't be put outside the loop. Previous Comments: --------------------------------------------------------------------------- [2000-11-29 12:13:32] fmk@php.net Divide your query into three. You dont need to set options at each query. Options should be ste once in each session. --------------------------------------------------------------------------- [2000-11-28 22:41:19] lingc@mail.nsysu.edu.tw I need to exec my sql statement with "set nocount on" and "set nocount off" within the for-loop by the function of mssql_query. But it seems only to be successful at the first time and the others were failed with the error message "MSSQL Query Failed". My platform is WinNT4.0sp4+Apache1.3.14+Php4.03pl1+MSSQL7.0sp2. The sql-statement is <pre> $db = mssql_connect("test","",""); for ($i=0;$i<=3;$i++){ $SQLstr = "set nocount on select news from table_news set nocount off"; $result = mssql_query($SQLstr,$db); print $result; } mssql_close($db); ======================== The result is: 1 Warning: MS SQL: Query failed in c:test.php3 on line 16 Warning: MS SQL: Query failed in c:test.php3 on line 16 </pre> I use the mssql profiler to trace the execution. I found that the sql statement was only executed at the first time and another times were not found. Is this is a bug of mssql_query ? Thanks anyway, Vicent,Lin. --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=8022