mssql_bind() couldn't process string parameter longer than 254 characters
| From: | Miroslav I. | Date: | Wed, 12 Nov 2003 13:12:11 +0000 |
| Subject: | mssql_bind() couldn't process string parameter longer than 254 characters | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-169263@lists.php.net to get a copy of this message | ||
Hi, people
- the first time in the list,
- subscribed only for few minutes and already have 7 messages :-) this is
promising!!!!!!
#The problem:
mssql_bind() (PHP Version 4.3.2-RC) couldn't pass string parameter longer
than 254 characters to the stored procedure (MSSQL2000 server)
##Is there a way to call stored procedure ( from PHP ) with long string
parameters?
###Additional:
- Warnings and PHP code lines related:
Warning: mssql_bind(): Unable to set parameter in
E:\Intranet\webtreb.fresh.co.yu\connections\insert_treb.php on line 59
< line 59: mssql_bind($kveri, "@item_treb1", $item_treb1, SQLVARCHAR, FALSE,
FALSE, 255); >
Warning: mssql_execute(): message: Procedure 'sp_tr_InsertTrebIDetails'
expects parameter '@item_treb1', which was not supplied. (severity 16) in
E:\Intranet\webtreb.fresh.co.yu\connections\insert_treb.php on line 70
Warning: mssql_execute(): stored procedure execution failed in
E:\Intranet\webtreb.fresh.co.yu\connections\insert_treb.php on line 70
< line 70: $result = mssql_execute($kveri); >
- PHP Manual (2003-09-06):
"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."