Hi all,



I am attempting to follow an example that I found on ASPFaq.com and am 

having troubles with returning multiple recordsets from a stored procedure 

execution.  The specific code is as below.



<%

    OrderNumber = "4"

 

    sql = "EXEC sp_DeleteOrder"

    sql = sql & " @OrderNumber ='" & FixString(OrderNumber) & "'"

 

    set conn = server.createobject("adodb.connection")



    conn.open Application("db_ConnectionString")

    set rs = conn.execute(sql)

        

    set rs = rs.NextRecordSet()

    Response.write(rs(0) & " rows deleted.")

    rs.close: set rs = nothing



  conn.close: set conn = nothing

%>

  Any help given would be greatly appreciated,



Thank you,



Jason L. Tienor

Interactive SolutionZ, LLC