If the list is not TOO long, you could simply: <cfquery...> select * from table where id in (#idList#) </cfquery>
(this assumes numeric ids, and a cf variable called idList) Jerry Johnson >>> [EMAIL PROTECTED] 01/29/03 09:46AM >>> I have a list of IDs and I want to create a Query that will find records based on this list. Is there an easy way to do this other than using a lot of ORs? T ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
