I've got a simple query that will grab all my navigational menu items.
pretty simple. Now, I've added Mike D's cf_maketree script to modify
the query by adding another field, called maketreesortlevel, that stores
the tree level so that I can output the menu items in the correct order
and depth. this query gets rather big, since I've got over 1300
categories and subcategories, so I'd like to be able to cache it. i
know how to use cachedwithin as a cfquery attribute, but this won't work
here, since I am modifying that query. is there another way to cache a
query? here's the code, if it helps:
<cfif NOT isdefined("qry_get_topcats") or isdefined("attributes.refresh")>
<cfquery name="qry_get_topcats" datasource="#Request.DS#"
username="#Request.user#" password="#Request.pass#"
cachedwithin="#Request.Cache#">
SELECT Category_ID, Name, Parent_ID, ParentIDs
FROM Categories
WHERE Categories.Display = 1
ORDER BY Priority, Name
</cfquery>
<!--- this script modifies the query to add 'maketreesortlevel' --->
<cfmodule
template="make_tree.cfm"
Query="#qry_get_topcats#"
Result="qry_get_topcats"
Unique="category_ID"
Parent="Parent_ID">
</cfif>
TY
Ray
--
=================================================================
Ray Champagne - Senior Application Developer
CrystalVision Web Site Design and Internet Services
603.433.9559
www.crystalvision.org
=================================================================
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219629
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
