Thanks for the reply. ROL.getcategorydetailnames()
Is actually a PostGRESQL function that is called within the <cfquery ...> The function only accepts one input (an integer) per iteration, so in my form that calls this page when someone selects more than one category I need the entire query to execute (and give output) for each category id ... (#mcategories#). The way I have it written it only gives the output for the last category id passed to it. The output I am looking for would look something like ... Category 1 - thing 1, thing 2, thing 3, thing 4 Category 2 - thing 11, thing 12, thing 13, thing 14 Category 3 - thing 20, thing 21 and so on ... I need to get the categories from user input and the "things" from the database with that function. The function works like a charm with just 1 category passed to it. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312769 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
