The below code solves my problem almost completely... instead of returning Level 1 >>
Level 2, it retures Level 2 << Level 1... but hey, it works! (code is free to any who
want it).
Does anyone know how I might return all the levels like so?
Brick and Mortar >> United States
Brick and Mortar >> United States >> Alabama
Brick and Mortar >> United States >> Alaska
....
Brick and Mortar >> United States >> Arkansas
Brick and Mortar >> United States >> Arkansas >> Sevier County
....
Brick and Mortar >> United States >> Illinois >> Cook County
Brick and Mortar >> United States >> Illinois >> Ford County
Brick and Mortar >> United States >> Illinois >> Iroquois County
Brick and Mortar >> United States >> Illinois >> Kankakee County
....
Brick and Mortar >> Canada >> Toronto
....
Internet Based >> Category 1
Internet Based >> Category 2
etc?
Thanks for all the help,
Tony Hicks
<font face='Verdana, Arial' size='-1'>
<cfloop from='1' to='10' index='CatID'>
<cfparam name='loop_parent' default='#page_parentid#'>
<cfquery name='loopthrough' datasource='s4s_seniorindex'>
select * from Categories
Where CatID=#loop_parent#
</cfquery>
<cfoutput query='loopthrough'>
<a href='?mode=#mode#&page_parentid=#Catid#&showpage=browse.cfm'>#category_name#</a>
<cfif catid neq 1><<</cfif>
<Cfset loop_parent='#parent_id#'>
</cfoutput>
</cfloop>
</font>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
