Why safer to lose the query ref? Adrian
-----Original Message----- From: Jason Fisher [mailto:[EMAIL PROTECTED] Sent: 11 November 2008 13:38 To: cf-talk Subject: Re: inserting a structure...within a structure...within a structure 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:315075 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
