Hello All! I need help...I am trying to access a store proc using the code below. When I test the proc in Enterprise Manager, it returns records, however it is not returning any records via the page. I copied the same syntax from another page in the website. Are there any limits to the number of columns asp can handle in a recordset?:

Dim objComm, objParam, strSite
Dim rsList 'recordset variable

Set objComm = Server.CreateObject("ADODB.Command")

objComm.ActiveConnection = sDSN
objComm.CommandType = adCmdStoredProc
objComm.CommandText = "uspFollowUp"

Set objParam = objComm.CreateParameter("@Site",adChar,adParamInpu t,6)
objComm.Parameters.Append objParam

strSite = "SITE09"
objComm.Parameters("@Site") = strSite

Set rsList = objComm.Execute

Set objComm = Nothing
Set objParam = Nothing

Cheers! Jenna:D