mssql_bind() couldn't process string parameter longer than 254 characters

From: 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."

« previous php.general (#169263) next »