Below is an example of passing in parameters when calling a stored procedure from an ASP page.
<%Dim aConnSet aConn = Server.CreateObject("ADODB.Connection")aConn.Open ConnectTo()strFrMo = cint(Request.QueryString("FrMo"))strFrYr = cint(Request.QueryString("FrYr"))strToMo = cint(Request.QueryString("ToMo"))strToYr = cint(Request.QueryString("ToYr"))aConn.Execute ("Execute sp_BusRev '" & strFrMo & "', '" & strFrYr & "', '"& strToMo & "', '" & strToYr & "'")%>