Question
Stored Procedure Problem
I'm breaking into Stored Procedures.
So far I've gotten a page to display my data...Good so far
Today, I've been trying to pull data onto a page after submitting a form.
This is the SP.
-----------------------
CREATE PROCEDURE searchresults(@searchfor varchar (6000))
AS
SELECT P.ID AS ProductID, P.Name, P.ProdID, P.Price, P.ClearSale,
P.SalePrice, P.ShipCost, G.gid, G.pid AS Gpid, G.ord, D.PID AS DPID,
D.Paragraph
FROM atblProducts P INNER JOIN Groups G ON P.ID = G.pid INNER JOIN PCat
PC ON G.gid = PC.gid LEFT JOIN Description D ON G.gid = D.PID
WHERE D.Paragraph LIKE @searchfor
ORDER BY G.gid, G.ord, P.ID, P.Name
GO
-----------------
When I am inside the Command window in Dreamweaver, and hit the test
button, no results appear. No errors but no results.
So far I've gotten a page to display my data...Good so far
Today, I've been trying to pull data onto a page after submitting a form.
This is the SP.
-----------------------
CREATE PROCEDURE searchresults(@searchfor varchar (6000))
AS
SELECT P.ID AS ProductID, P.Name, P.ProdID, P.Price, P.ClearSale,
P.SalePrice, P.ShipCost, G.gid, G.pid AS Gpid, G.ord, D.PID AS DPID,
D.Paragraph
FROM atblProducts P INNER JOIN Groups G ON P.ID = G.pid INNER JOIN PCat
PC ON G.gid = PC.gid LEFT JOIN Description D ON G.gid = D.PID
WHERE D.Paragraph LIKE @searchfor
ORDER BY G.gid, G.ord, P.ID, P.Name
GO
-----------------
When I am inside the Command window in Dreamweaver, and hit the test
button, no results appear. No errors but no results.
AdChoices