I like this method better (Michael's) because it's cleaner (and the DB should be doing the work - SQL2K), but the top 5 have the ability to change all the time. I'll never know what they are.
So passing the ID's thru the URL I think will be the next best thing here. I'm still telling the client it's not ideal. If I was a user - I'd forget that there were 5 missing from the "more" section, therefore never seeing them again. On Tue, Mar 17, 2009 at 9:49 AM, Michael Grant <[email protected]> wrote: > where id not in ( > select top 5 ID > from whatevs > ) > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:292028 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
