I see what this is supposed to do, but for the life of me I can't get it to work. Shannon
>For each directory, you could to a Query of Queries on the existing >query to see if there are any records with parent equal to the current >directory and type="file". If that RecordCount is zero, then you have a >directory-only directory. > > ><cfquery name="qFile" dbtype="query"> > SELECT name > FROM qDir > WHERE type = 'File' AND > parentdirectory = '#qDir.parentdirectory#\#qDir.name#' ></cfquery> > ><cfif NOT qFile.RecordCount></cfif> > > >I can't remember off hand if it's Parent or ParentDirectory... But >something like that would work (not sure how efficient it is). > >-Ben > > >..................... >Ben Nadel >Certified Advanced ColdFusion MX7 Developer >www.bennadel.com > >Need ColdFusion Help? >www.bennadel.com/ask-ben/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277613 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4