SQL server procedore how to
| From: | Noam Giladi | Date: | Sun, 23 Feb 2003 09:01:19 +0000 |
| Subject: | SQL server procedore how to | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25857@lists.php.net to get a copy of this message | ||
i have a aprocedure "simple_proc"
i try to call her with mssql_query like this:
----------------------------------------------------------------
$q="exec simple_proc";
$ret = mssql_query($q,$__["db connection"]);
----------------------------------------------------------------
the result i get is:
---------------------------------------------------------------
Resource id #20
--------------------------------------------------------------
insted of getting the resulets the proc is returning
what should i do??
tnx noam.
by the way ,if i use the sql server "Query Analyzer", i'm getting the wanted
results