[PHP-DB] SQL server procedore how to

2003-02-23 Thread Noam Giladi
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




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



Re: [PHP-DB] SQL server procedore how to

2003-02-23 Thread Mark
You need to ue mssql_fetch_*() to actually put the data into an
array.

--- Noam Giladi [EMAIL PROTECTED] wrote:
 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
 
 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 


=
Mark Weinstock
[EMAIL PROTECTED]
***
You can't demand something as a right unless you are willing to fight to death to 
defend everyone else's right to the same thing.
***

__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/

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