A little OT, but you can save some keystrokes with proper use of the '#' symbol. Safer to lose the internal reference to the query inside the loop, too:
<cfquery name="cats" datasource="#Application.DSN#"> .... snip .. </cfquery> <cfloop query="cats"> <cfif NOT StructKeyExists(allcats, category)> <cfset allcats[category] = StructNew()> <cfset allcats[category].created = 0> <cfset allcats[category].catid = acategoryid> </cfif> <cfif NOT StructKeyExists(allcats[category], subsection)> <cfset allcats[category][subsection] = StructNew()> <cfset allcats[category][subsection].created = 0> <cfset allcats[category][subsection].catid = categoryid> </cfif> <cfif NOT StructKeyExists(allcats[category][subsection], manuf)> <cfset allcats[category][subsection][manuf] = StructNew()> <cfset allcats[category][subsection][manuf].created = 0> <cfset allcats[category][subsection][manuf].l3catid = l3catid> </cfif> </cfloop> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-talk/message.cfm/messageid:315074 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4