Click to See Complete Forum and Search --> : Changing recordSource in ASP ADO


spuppett
February 16th, 2005, 09:04 AM
I am a VB programmer, but have been charged with writting an asp page to validate some data. I have in the past used DAO and a little ADO.

What I need to do is open my DB using an SQL statement. I've done this part successfully. After I've verified some things I need to run a new query. This is where my problem is. In vb its just rs.recordsource = "SELECT * that I want....", but from what I've seen VBScript doesn't use the recordSource property.

My question then is, how do I run a new query??

Thank you much

spuppett
February 16th, 2005, 09:22 AM
Nevermind I got that part figured out. Had to close the rs, then reopen it I guess.