May I be so pertinant as to ask why it must be so? i.e. it may be more efficient and easier to read to do that bit in ColdFusion. So get the query to return like:
permit info,company1 permit info,company2 Then, if you were outputting to excel for example, do: <tr> <cfoutput query="thequery" groupby="permitId"> <td>#permitName#</td> <cfoutput> <td>#companyname#</td> </cfoutput> </cfoutput> </tr> I do realise this may not be what you are after, but I would most likely be inclined to let coldfusion deal with that kind of stuff if possible. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297282 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
