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
