This is a discussion on Is there a limit of mssql_bind calls you can make when calling mssql_execute? within the PHP Language forums, part of the PHP Programming Forums category; It seems that the maximum number of parameters I can bind using mssql_bind and an execute statement is 30. If ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
It seems that the maximum number of parameters I can bind using
mssql_bind and an execute statement is 30. If we go beyond we get an error of "mssql_execute(): could not retrieve results". Can anyone confirm that this is a limitation (of PHP4 or of MSSQL 2000) and if so, can it be modified? When we use mssql_query we can go beyond 30 parameters. Unfortunately there is a case where using mssql_query is not an option. Thanks, Greg |
|
|||
|
There is a bug in MSSQL Client Libraries that avoid sending varchar
parameters for more than 255 characters to a stored procedure. Use mssql_query instead. http://ie2.php.net/manual/en/function.mssql-bind.php Could this be the reason? |