Recordset problems

[ecnarongi]

Hello all,

I have a recordset and I want to move to the next record but I need to get the values of the next record before I go to the next page.

I thought recordsetname.movenext("Value") would work but it didn't. I also thought about assigning a new recordset to equal recordsetname.movenext but that doesn't even sound right. Can anyone help? All help is appreciated.

[ecnarongi]

Ok, maybe someone can help me with this. How do I start at a particular record? Say I want to create a recordset off all the records in the table starting where name="john". All help is appreciated.

[waj_muller]

Use this
resordset.Filter="columname=criteria"

this will filter all the records according to the search..
You can use recordset.find also but this will be a more accurate find specific on the search criteria where filter will be a search on the criteria and if you use wildcards with it the abreviations of it asswell.

Look in the iis documentation,they list all the properties there.
Be careful when using these properties they are extremely resource unfriendly.
Use them only when you know that the search will not require massive database scanning.
Each scan is done individually as separate calls to the database.So this can chew up memory like hell..
Use sql profiler to see the calls.