not getting results back from store procedure. 1

[Shadowspawn65]

Hi,

In the following procudure I'm not getting any results back. I think I'm missing something simple...any advice?

	Select Case Value
		Case "Menu" 
			Response.Write("MealId="&MealID&"<br/>")
			dbComm.CommandText = "sp_GetMenuItems"			
			dbComm.Parameters.Append dbComm.CreateParameter("MealID", adInteger, adParamInput, 4,2)
			dbComm.Parameters.Append dbComm.CreateParameter("ItemID", adInteger, adParamReturnValue)
			dbComm.Parameters.Append dbComm.CreateParameter("GroupID", adInteger, adParamReturnValue)			
			dbComm.Execute


	End Select
	If Value <> "Menu" Then
		Set rsLoop = getConnection.Execute(strSQL)
	Else
		
		Response.Write("The ItemID is "& dbComm.Parameters(1).Value&"<br />")
		Response.Write("The GroupID is "& dbComm.Parameters(2).Value&"<br />")
	End If

when the above code is run i get nothing printed for ItemID or GroupID

Thanks!

 

[DreXor]

what if case is not menu?

and what's strsql?

dbcomm would contain your recordset if your sp returns a recordset, and you would use it as a recordset object.



DreX
aKa - Robert