I have a page that attempts to call the mssql_query function with a very large query string (i.e. about 34000 characters). This errors out (mssql_query() failed in...). I can copy and paste the query into the SQL Server Query Analyzer, and it seems to work fine. Is there a limit on how big the query string for the mssql_query() function can be?
have a look at mssql.textlimit and mssql.textsize in your php.ini
Both were commented out. I un-commented them, and changed the value to the maximum on both (2147483647), but it didn't seem to have an effect.
Forgot to mention that I'm using PHP 5.0.2, IIS 5.
