ASP Query a recordset.

[Newsgroup_User]

If I create a recordset in ASP is it then possible to perform a query on the
recordset so that only certain data in the recordset is shown, a bit like a
view of the recordset?

[Newsgroup_User]

You can filter a recordset after it has been created. eg

RS.Filter="ID=5"

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Angell EYE]

After you create the recordset you can run filters on it to display only certain data on the page. You can even create a filter, display that data, then turn off the filter and create another one to display different data from the same recordset.

http://www.devguru.com/technologies/ado/QuickRef/recordset_filter.html