Results 1 to 3 of 3
Jul 16, 2002, 07:28 #1
- Join Date
- Sep 2001
- 0 Post(s)
- 0 Thread(s)
PHP, Stored Procedures and MS SQL
Ok, I got a interesting problem.
I currently have a number of stored procedures that I pass paramaters to. Everything is working fine, however, there are certain parameters that I cannot pass to these Stored Procedures:
$Query_wp = ("EXECUTE sp_Product_All $ID");
$Row_wp = mssql_fetch_object($Result_wp);
CREATE PROCEDURE sp_Product_All @Row_wp->Product int
SELECT ID, Articlenumber, Web_Name, Image FROM Product
I am getting an syntax error for @Row_wp->Product. I have tried variations of this syntax, but no joy. Any suggestions?
Thanks.I have two tickets to the Crows, sweet.