Post your block of code from your connection string (Leave out your username/password info please) to the end of the result set for your query so I can take a look at it. On 5/9/07, Chris Boget <chris.boget@xxxxxxxx> wrote:
I noticed the following in my logs: 22:04:42 [warning] [D:\PHP\pear\DB\mssql.php][439]: mssql_query(): Unable to set query 22:04:42 [info] Backtrace: [D:\PHP\pear\DB\mssql.php][439]; function( mssql_query ); args( 1[value:select @@ERROR as ErrorCode] 2[value:Resource id #21] ) 22:04:42 [info] Backtrace: [D:\PHP\pear\DB\mssql.php][489]; function( errornative ) 22:04:42 [info] Backtrace: [D:\PHP\pear\DB\mssql.php][145]; function( mssqlraiseerror ) 22:04:42 [info] Backtrace: [D:\PHP\pear\DB\common.php][1146]; function( simplequery ); args( 1[value:SELECT * FROM wording WHERE wording_id = '8' ] ) 22:04:42 [critical] Error in the following query:<br><br>SELECT * FROM wording WHERE wording_id = '8' <br>DB Error: unknown error 22:04:52 [warning] [D:\PHP\pear\DB\mssql.php][439]: mssql_query(): Unable to set query 22:04:52 [info] Backtrace: [D:\PHP\pear\DB\mssql.php][439]; function( mssql_query ); args( 1[value:select @@ERROR as ErrorCode] 2[value:Resource id #21] ) 22:04:52 [info] Backtrace: [D:\PHP\pear\DB\mssql.php][489]; function( errornative ) 22:04:52 [info] Backtrace: [D:\PHP\pear\DB\mssql.php][145]; function( mssqlraiseerror ) 22:04:52 [info] Backtrace: [D:\PHP\pear\DB\common.php][1146]; function( simplequery ); args( 1[value:SELECT * FROM wording WHERE wording_id = '8' ] ) 22:04:52 [critical] Error in the following query:<br><br>SELECT * FROM wording WHERE wording_id = '8' <br>DB Error: unknown error Why is mssql_query() saying that it's unable to set the query? I did some searching on Google and found that people were having this problem but that was back in 2001 using an earlier version of PHP. We are using version 4.3.11 and Microsoft SQL Server 2000 - 8.00.2039 (Intel X86). Has anyone had a similar problem? What was your solution? Why is this happening? thnx, Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
