Saving Resultset to Session or Request Scope
Posted on 2005-04-23
With the following code, and where I put my comment, I want to save this resultset to a request scope (or session). How do you do both, and how do you pull it out and iterate through it when you want to retrieve it on another page? I know in Java it is request.setAttribute("SOMETHING",somethingsValue); but I don't know it in ASP.
Here is my code:
Set Con = Server.CreateObject( "ADODB.Connection" )
DIM questionSQL, questionRs
questionSQL = "SELECT quizid, difficultytype, maxnumberofquestions from quiz"
SET questionRs = con.execute(questionSQL)
' I want to save to request scope here