Hi all.

I can't get my stored procedure working. Let me show your:

what I want to work
intContentID = Request.Form("ContentID")
strContentPage = Request.Form("ContentPage")
strSQL = "qryVerifyContent (" & CLng(intContentID) & ", '" & CStr(strContentPage) & "')"
Set objRSVerify = objConn.Execute(strSQL)

what does work
intContentID = Request.Form("ContentID")
strContentPage = Request.Form("ContentPage")
strSQL = "SELECT Content.ContentText " & _
         "FROM Content " & _
     "WHERE (((Content.ContentID)=" & intContentID & ") AND ((Content.ContentPage) Like '" & strContentPage & "'));"
Set objRSVerify = objConn.Execute(strSQL)

But I keep getting an error...
My storedProc is this:
PARAMETERS intContentID Long, strContentPage Text ( 255 );
SELECT Content.ContentText
FROM Content
WHERE (((Content.ContentID)=[intContentID]) AND ((Content.ContentPage) Like [strContentPage]));
I think it's something with the parameters...

All help is appreciated - Jon

Regards - Jon

__________________
- mega
Aspiring JavaScript Ninja

And what is the error?


Hal Levy
Daddyshome, LLC

Stupid me forgot that you can't query a sproc with the connection object. I used the Recordset object and it worked out fine.
Do you know if there is any performance advantage if I used the Command object instead? I'm just retrieving a single value to compare in VBScript. I might compare directly in the SQL. Hmm.. I will not be doing it that often, maybe it's not worth it...

Regards - Jon