[RESOLVED Temporarily] Filtering

[RobDog888]

Is it possible to filter a resultset of a db query? I dont want to hit the db with two calls and my query is joined to bring the related resultset back but upon iterating it may be best to loop through the one condition and then reloop through the other. There will be no duplication of items in the loop so its not a resource drain or waste.

For ex. if you have returned items that can be visible and invisible then it would be a waste to call the db twice just to loop through the visible ones and then another call and loop through the invisible ones. So if I have 5 visible and 5 invisible items then I only want to loop a total of 10 times; filter for visible, loop 5 times, unfilter, refilter for invisible, loop 5 more times and release resources.


Thanks