ok... I'm new to CF and I can't exactly remember how CFLOOP works but here goes.
<cfset status_count = 1> <cfquery name="eventlist1"> SELECT * FROM EVENTS WHERE PERMISSIONS IN ( <CFLOOP> <CFIF status_count EQ 1> #session.status# <cfset status_count = 2> <CFELSE> ,#session.status# </CFIF> ) ORDER BY EVENT_DATE, EVENT_START ASC </cfquery> Assuming I remembered how CFLOOP worked, it should work. If now, I'm pretty sure there's another way, but I can't test anything until I get into the office. Also if PERMISSIONS is NOT an INT field, you'll need the single quote like below. <cfset status_count = 1> <cfquery name="eventlist1"> SELECT * FROM EVENTS WHERE PERMISSIONS IN ( <CFLOOP> <CFIF status_count EQ 1> '#session.status#' <cfset status_count = 2> <CFELSE> ,'#session.status#' </CFIF> ) ORDER BY EVENT_DATE, EVENT_START ASC </cfquery> - Dae ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287752 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4