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

Reply via email to