Handling ResultSet data in ASP
Posted on 2013-05-10
I have declared a database connection as follows
Set Conn = Server.CreateObject("ADODB.Connection")
RS = Conn.Execute("SQL")
This returns a resultset object as expected, what I am looking for is a way to query the resultset further to get more accurate results within my asp page. Is this possible - I imagine the modern day equivalent is something like LINQ? If not can I get the resultset into another object type that is easier to query.