Yes, there's a Filter property on the recordset object, which is what I'm using.
The reason for the filtering being done that way is more for practical reasons within the structure of the code - there are a lot of conditions, and the SQL would get pretty complex. I'm not bothered about complex SQL by any means, but figured if it works and isn't slowing me down, why change it? Anyway, after some more involved debugging, GetRows() appears to be functioning correctly, so I'm off hunting in another direction (again!) Thanks, Dan www.diado.com -----Original Message----- From: Paul Manzotti [mailto:[EMAIL PROTECTED] Sent: 11 October 2004 10:05 To: [EMAIL PROTECTED] Subject: Re: [ASP] Does GetRows() return filtered recordsets? 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 --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
