Thanks for the reply Kris. I implemented a design scheme suggested by others to warehouse categories for a classifieds ad system. I was using 2 tables and now am just using one table to populate the navigation menu. Problem is that when I drill down in the menu to the point where there is no more records left to populate the menu, it simply vanishes due to not having records to build off of. This did not happen in the old scheme of 2 tables. Just trying to find a way to fix it.
----- Original Message ----- From: "Kris Jones" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, August 22, 2006 6:03 AM Subject: Re: Getting the last url variables > Not sure what your menu issue is, but to get the last URL variable if > your recordset is empty might look something like this: > > <cfset mylasturlvar = "" /> > <cfif rcdset.recordcount is 0> > <cfset mylasturlvar = listlast(cgi.query_string,"=") /> > </cfif> > > Cheers, > Kris > > > I am trying to find out how to set the last url variable on a page if the query I am running has no recordcount. Basically I am populating a table with categories from the database and when there is no more records the menu dissapears. This is not what I want. When there is no records for a particular set of categories, I just want that menu to stay on the page unless the user clicks back to the previous menu. Any Ideas? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:250579 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
