> ---------------------- > ID* - Active - Approved > ---------------------- > 12 - No - Yes > 23 - No - No > 24 - No - Yes > 29 - Yes - Yes > 32 - Yes - Yes > 33 - No - Yes > 40 - No - No
> I think you'll have to fill us in on why 33, and 12 "meet the > criteria" Because they're the "next" records in the table WHERE Approved = Yes AND active = No. 40 has to be ignored because Approved = No. I know how to find all records that are "approved," or "active," or whatever - but I don't see how I can get the "next 2." A friend suggested doing something like WHERE ID > #previousID# - only problem with this is if the CURRENT ID was 40 (as per the table above), it wouldn't pickup on 12 which is the logical next record. Sorry, I'm not explaining myself properly here at all - if anyone has any other ideas they'd be much appreciated Will ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
