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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to