Link to home
Create AccountLog in
Avatar of Blowfelt82
Blowfelt82

asked on

Handling ResultSet data in ASP

I have declared a database connection as follows

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "..."
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.
ASKER CERTIFIED SOLUTION
Avatar of Ersoy Hasan
Ersoy Hasan
Flag of Bulgaria image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Big Monty
the best way to filter it would be directly in the sql:

select from table where field = 'xxx'