RE: Dir listing with cfdirectory
Sorry, the column name is "directory" qDir.directory .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Shannon P [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 10:54 AM To: CF-Talk Subject: Re: Dir listing with cfdirectory I get "Element PARENTDIRECTORY is undefined in QDIR." or "Element PARENT is undefined in QDIR." removing #qDir.parent#\ I get a new error " Error Executing Database Query. Query Of Queries runtime error. The select column reference [parentdirectory] is not a column in any of the tables of the FROM table list." If I try parent instead of parentdirectory I get the same thing. Shannon ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277625 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Dir listing with cfdirectory
The only issue I see is to truly determine that a folder ONLY contains folders, is that you have to access each of the subdirectories within the said folder to check if any files exists. If so, then it does not meet your requirement. So you would need to do a recursive listing for each directory involved. Just by checking the contents of the first folder and no files listed there does not mean that the subfolders do not have files within them. -Original Message- From: Shannon P [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 10:54 AM To: CF-Talk Subject: Re: Dir listing with cfdirectory I get "Element PARENTDIRECTORY is undefined in QDIR." or "Element PARENT is undefined in QDIR." removing #qDir.parent#\ I get a new error " Error Executing Database Query. Query Of Queries runtime error. The select column reference [parentdirectory] is not a column in any of the tables of the FROM table list." If I try parent instead of parentdirectory I get the same thing. Shannon >Is it throwing an error? Or just not doing what you want? > > >. >Ben Nadel >Certified Advanced ColdFusion MX7 Developer www.bennadel.com > >Need ColdFusion Help? >www.bennadel.com/ask-ben/ > >-Original Message- >From: Shannon P [mailto:[EMAIL PROTECTED] >Sent: Thursday, May 10, 2007 9:24 AM >To: CF-Talk >Subject: Re: Dir listing with cfdirectory > >I see what this is supposed to do, but for the life of me I can't get >it to work. >Shannon ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277624 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dir listing with cfdirectory
I get "Element PARENTDIRECTORY is undefined in QDIR." or "Element PARENT is undefined in QDIR." removing #qDir.parent#\ I get a new error " Error Executing Database Query. Query Of Queries runtime error. The select column reference [parentdirectory] is not a column in any of the tables of the FROM table list." If I try parent instead of parentdirectory I get the same thing. Shannon >Is it throwing an error? Or just not doing what you want? > > >. >Ben Nadel >Certified Advanced ColdFusion MX7 Developer >www.bennadel.com > >Need ColdFusion Help? >www.bennadel.com/ask-ben/ > >-Original Message- >From: Shannon P [mailto:[EMAIL PROTECTED] >Sent: Thursday, May 10, 2007 9:24 AM >To: CF-Talk >Subject: Re: Dir listing with cfdirectory > >I see what this is supposed to do, but for the life of me I can't get it >to work. >Shannon ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277622 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Dir listing with cfdirectory
Is it throwing an error? Or just not doing what you want? .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Shannon P [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 9:24 AM To: CF-Talk Subject: Re: Dir listing with cfdirectory I see what this is supposed to do, but for the life of me I can't get it to work. Shannon ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277620 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dir listing with cfdirectory
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. > > > > SELECT name > FROM qDir > WHERE type = 'File' AND > parentdirectory = '#qDir.parentdirectory#\#qDir.name#' > > > > > >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
RE: Dir listing with cfdirectory
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. SELECT name FROM qDir WHERE type = 'File' AND parentdirectory = '#qDir.parentdirectory#\#qDir.name#' 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/ -Original Message- From: Shannon P [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 09, 2007 2:13 PM To: CF-Talk Subject: Dir listing with cfdirectory I'm creating a page that creates a listing of directories and subdirectories with their contents. Everything seems to work great, but I'd like a folder with only folders inside to show up bold. Any ideas? Tia, Shannon Here's a copy of what I have now #qDir.name# #qDir.name# #qDir.size# (bytes) ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277490 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4