I am still having problems with the display of this darn menu for my site. When
there is no more data to fill the menu with categories, after people drill
down, the menu simply dissapears. I have tried the below code, but it only
reloads the last menu item the user clicked and therefore only shows 1 category
being in the menu. Would it be a bad thing to load each users menu into session
scope and rebuild an array based upon which category the user is visiting? If
this would work, how would you implement it?
<cfquery datasource="goBuddy" name="get_subs">
select * from cat_test where cat_test.parent_id = #url.cat_id#
</cfquery>
<cfset lastid = get_subs.cat_id>
<cfif get_subs.recordcount EQ 0 AND IsDefined("url.cat_id")>
<cfquery datasource="goBuddy" name="get_subs">
select * from cat_test where cat_test.parent_id = (select cat_id from cat_test
where cat_id = #url.cat_id#)
</cfquery>
</cfif>
thanks alot folks
Doug B
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250704
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
