Stored proc
| From: | Louis Young | Date: | Tue, 18 Jan 2005 09:26:58 +0000 |
| Subject: | Stored proc | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-25378@lists.php.net to get a copy of this message | ||
Hi Guys
I'm trying to execute an MSSQL 2000 stored proc in PHP:
This:
$sp_FINGPDebtorBalance_query=mssql_query($_GLOBALS["GPDB"] . "sp_FINGPDebtorBalance_rset '" . trim($Outlet_session) . "E', 0");
produces the following:
*Warning*: mssql_query(): Query failed in *c:\program files\apache group\apache\htdocs\spar\admin\rpt_electrans.php* on line *172
If I echo the parameter of mssql_query and copy and paste it into SQL Query Analyzer it works fine.
Any ideas what I might be missing?
Cheers
Louis
*