I'll admit that I didn't read your email completely, but could it be
that you need to clear thisTag.GeneratedContent in one of your custom
tags, or maybe a loop has a funny index?
Jamie
On Mon, 8 Jul 2002 22:24:11 -0500, in cf-talk you wrote:
>I have a custom tag (code below) that I am calling upon itself to grab all of the
>departments in the db and building lists such as:
>
>Men's Clothing
>Men's Clothing/Shirts
>Men's Clothing/Shirts/Long Sleeve
>Men's Clothing/Shirts/ShortSleeve
>Men's Clothing/Pants
>Women's Clothing
>Women's Clothing/Shirts
>ect..
>
>The problem with this tag is that the VERY LAST output doubles ... so in the example
>above Women's Clothing/Shirts would be listed twice (if it were the last one) It is
>always the last record.
>
>Can anyone see where the problem lies?
>
>Sorry for the looong code but it is the only way to figure this one out.
>
>============ Code ====================
>
><cfif IsDefined("request.catalog_list") Is "No">
> <cfset request.catalog_list = ArrayNew(1)>
></cfif>
>
><cfparam name="attributes.table" default="#prefs.department_table#">
>
><!--- this is the list that we're building. Prefixing it with 'request' means that
>any custom tag at any level of execution has access to it. Think of it as a
>temporary application variable. --->
><cfparam name="request.catalog_list" default="">
>
><!--- this is the value each instance of this custom tag will use to decide what
>elements it's looking for out of the database. The default value is 'index' since
>that's your designation for the top of the catalog tree. --->
><cfparam name="attributes.owner" default="#prefs.indexid#">
>
><!--- this is the value each instance of this custom tag will preface values it adds
>to the listing with. Because the database only contains each item's immediate
>parent/child value, we have to pass this forward. --->
><cfparam name="attributes.path" default="">
>
><!--- go get the children for the base owner value we're supposed to be looking for
>--->
><cfquery datasource="#prefs.dsn#" name="getChildren">
> SELECT f.owner, f.sub_object, d.id, d.title
> FROM #prefs.fusion_table# f, #attributes.table# d
> WHERE f.sub_object = d.id
> AND f.owner = '#attributes.owner#'
> AND f.type = 'department'
> ORDER BY d.title, f.sub_object
></cfquery>
>
><!--- Loop over the children of the main owner value. Our one and only loop. --->
><cfloop query="getChildren">
>
> <cfparam name="request.count" default="0">
> <cfset request.count = request.count + 1>
>
> <!--- add the path from the index to this location in the tree in front of the name
>of this sub-object --->
> <cfset variables.thisitempath = "#attributes.path#/#getChildren.title#">
> <cfset request.catalog_list[request.count] = StructNew()>
> <cfset request.catalog_list[request.count].tree = variables.thisitempath>
> <cfset request.catalog_list[request.count].id = getChildren.sub_object>
> <!--- Add an item to our list of catalog departments --->
> <cfset temp = ArrayAppend(request.catalog_list, request.catalog_list[request.count])>
> <!--- call this file again, but this time tell it to take a look at the next
>level down. if there's anything under this department, it will get added to the tree
>in sequence. --->
> <cf_catdump owner="#sub_object#" path="#variables.thisitempath#">
>
></cfloop>
>
>
>Thanks In Advance!
>Paul Giesenhagen
>QuillDesign
>
>
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
