Stored Procedure and recordset problems

[SchuhTL]

I have a stored procedure that I know is executing (sql query profiler) correctly and returning results however I am having problems filling session varables with the results of the recordset. Why am I doing wrong with the recordset?

set objConn = server.CreateObject("ADODB.Command")
set rsRTest = server.CreateObject "ADODB.recordset")
objConn.ActiveConnection = strConnect objConn.CommandText = "usp_GetTest"
objConn.CommandType = adCmdStoredProc
set objParam =(objConn.CreateParameter "@parm1",adVarChar, adParamInput, 50)

objConn.Parameters.Append ObjParam
objConn.Parameters("@parm1")= session("user")

set rsTest = objConn.Execute

if not rsTest.EOF then
session("Request") = rsTest("Request")
session("Group") = rsTest("Group")
end if

 

[DreXor]

these links might be of assistance :

http://www.vbip.com/books/1861001789/chapter_1789_10.asp

http://support.microsoft.com/kb/q224591/

http://support.microsoft.com/kb/195047/EN-US/

my guess is your SP in query analyser is showing records, but your SP doesn't have a select statement in it

DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!

 

[SchuhTL]

DreXor,

Thanks for the quick response, when looking at the links provided it looks like I am doing everything correctly. Here is my stored proc. In query profiler I can see that the proc is being executed with the correct parameter. I am so confused?????

CREATE PROCEDURE dbo.usp_GetTest
@parm1 varchar(50)
AS

SET NOCOUNT ON

SELECT * from Testtable where user = @parm1

GO