There is a function in my SQL Server 2008, which returns a resellet and some output variable.
From PHP, I need to get value with sqlsrv library.
I have this code, which I tested with a stored procedure and worked fine.
  & lt ;? Php $ serverName = "(local) \ MSSQLSERVER, 1433"; $ ConnectionInfo = array ("database" = & gt; "xxxx", "UID" => "xxxx", "PWD" => "xxxx"); $ Conn = sqlsrv_connect ($ serverName, $ connectionInfo); If (! $ Conn) {dead (;); } $ Tsql_callSP = "call {my_function (?,?)}"; $ Ret_cod = ""; $ Ret_desc = ""; $ Params = array (array ($ ret_cod, SQLSRV_PARAM_OUT), array ($ ret_desc, SQLSRV_PARAM_OUT)); $ Stmt = sqlsrv_query ($ conn, $ tsql_callSP, $ params); If ($ stmt === incorrect) {debug ("error in executing statement"); Die (debugs (sqlsrv_errors (), true)); } The error result is:    [microsoft] [odbc driver for SDC server 11] [sql server] 'my_function' for error message . 'My_function' is with a reluctant laugh 
 
  I know there is a syntax error, but how do I do this? Find examples on the Internet. 
  Try I, 
   $ tsql_callSP = "? = {Call_my_function (?,?)}";     
  
  / html> 
 
 
No comments:
Post a Comment