Dan Powderhill wrote: >However I am having a problem which I'm having trouble pinning down. >Here's the situation. The existing code creates a recordset from a >simple select query (against access 2K). Then it loops through a given >number of times and filters the recordset at the beginning of the loop >before processing the data. I've converted this over to GetRows() but >the filtering is done on the recordset before GetRows() is called. I >assumed that applying a filter to a recordset and calling GetRows() >would result in only the filtered data being returned in the array. Is >this the case, or will GetRows()return every record in the recordset? > >Any help would be appreciated... it's Monday morning, you know the >story! Lol > > To be honest, my first thought here, if you are filtering out information from the recordset, is that you should let the database do the filtering. Can you not call a different query based on the filtering needed? Other than that, I can't say that I know a lot about applying filters to a recordset (i.e. is there a recordset.filter operation that you are using, or do you just mean you have some code that checks each row?).
manzo ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
