Is there a limit of mssql_bind calls you can make when calling mssql_execute?

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 ...


Go Back   Usenet Forums > PHP Programming Forums > PHP Language

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 01-05-2006
gharmel
 
Posts: n/a
Default Is there a limit of mssql_bind calls you can make when calling mssql_execute?

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

Reply With Quote
  #2 (permalink)  
Old 01-06-2006
Sean
 
Posts: n/a
Default Re: Is there a limit of mssql_bind calls you can make when calling mssql_execute?

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?

Reply With Quote
  #3 (permalink)  
Old 01-07-2006
gharmel
 
Posts: n/a
Default Re: Is there a limit of mssql_bind calls you can make when calling mssql_execute?

It doesn't seem to be the problem since we've duplicated it with many
different stored procedures and they always fail on the 31st parameter
added.

Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT +1. The time now is 11:53 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0