|
'This is where you instantiate the object and make the
'database connection Set Conn = Server.CreateObject("SPRecSet.clsGetRecSet") 'Check for errors with the object If Trim(Conn.GetError) <> "" Then Response.Redirect("ErrorPage.asp?Error=" & Conn.GetError) 'Create the recordset object Set RecSet = server.CreateObject("ADODB.Recordset") 'Populate the recordset object *** taking special note of the stored proc name, then a comma, then whatever parameters Set RecSet = Conn.Execute("sp_get_subset_of_data," & intVariable) |