Skip to main content
Inspiring
August 28, 2006
Question

ASP Query a recordset.

  • August 28, 2006
  • 2 replies
  • 623 views
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?


This topic has been closed for replies.

2 replies

Angell EYE
Inspiring
August 28, 2006
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
Inspiring
August 28, 2006
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