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:
Now say from the Query above, I get the following variable:
$Query_wp = ("EXECUTE sp_Product_All $ID");
$Row_wp = mssql_fetch_object($Result_wp);
Everything is cool, but then I have a problem when I try to envoke my Stored Procedure:
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?