Querying UniqueIdentifiers

[cpope]

I have a stored procedure in SQL Server 7 that takes in a uniqueidentifier type from an ASP, the stored procedure is as follows:

CREATE PROCEDURE getinfo(@status uniqueidentifier) AS
SELECT ...
FROM ...
WHERE getinfoid=@status

The uniqueidentifier string is being grabbed from the querystring and the stored procedure is being called from the recordset variable as follows:

objRec.Open "getinfo "& status,objConn,,adCmdStoredProc

[sig][/sig]

 

[cpope]

Never mind, I figured it out, it was within my stored procedure call, I should have included the single quotes around the uniqueid string grabbed from the querystring...

objRec.Open "getinfo '"& status &"'",objConn,,adCmdStoredProc



[sig][/sig]