Re: Sort by file extension in CFDIRECTORY
It does, unfortunately it doesn't have the file extension as part of the object, so you'll need to add that column to the query object and run through the results separating the file name and filee xtension out to then sort by either column interchangeably. Nick I'd look at putting it into a custom query object and using queries of queries. So loop over the cfdirectory output inserting into a new query object that has file extension as a column and use a call like (filename,listLen(filename,.)-1,.) to retrieve the extension. Once it's stored it's a simple matter of query of queries to sort the results. I'm pretty sure that CFDIRECTORY returns a query object that can directly be sorted using query of queries. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359047 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Sort by file extension in CFDIRECTORY
It does, unfortunately it doesn't have the file extension as part of the object, so you'll need to add that column to the query object and run through the results separating the file name and filee xtension out to then sort by either column interchangeably. Good point! Sometimes I forget we can't just use ANSI SQL-92 substring functions in query of queries. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359053 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Sort by file extension in CFDIRECTORY
Interesting... You might be able to use a query of queries after you gotten the file list... Or you might recourse the directory to get the extension then do a separate query on each extension. That's an interesting question... I'm going to watch for what others say. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austi ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359037 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Sort by file extension in CFDIRECTORY
I'd look at putting it into a custom query object and using queries of queries. So loop over the cfdirectory output inserting into a new query object that has file extension as a column and use a call like listGetAt(filename,listLen(filename,.)-1,.) to retrieve the extension. Once it's stored it's a simple matter of query of queries to sort the results. Nick Can anyone point to an easy way to sort the display of CFDIRECTORY filenames by file extension, and then perhaps by name? -- Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359042 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Sort by file extension in CFDIRECTORY
I'd look at putting it into a custom query object and using queries of queries. So loop over the cfdirectory output inserting into a new query object that has file extension as a column and use a call like (filename,listLen(filename,.)-1,.) to retrieve the extension. Once it's stored it's a simple matter of query of queries to sort the results. I'm pretty sure that CFDIRECTORY returns a query object that can directly be sorted using query of queries. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359043 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Sort by file extension in CFDIRECTORY
I finally solved the problem this way: 1. if the page nb. does not exists: cfheader statuscode=404 statustext=Page not found CFABORT 2. in IIS I defined a URL to be called in case of error 404, this page displays a friendly message, then it also has to declare cfheader statuscode=404 statustext=Page not found (fortunately, IIS won't call the URL a second time, and loop) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359044 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Sort by file extension in CFDIRECTORY
I think you replied to the wrong thread there Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Thu, Jul 31, 2014 at 11:49 AM, wrote: I finally solved the problem this way: 1. if the page nb. does not exists: cfheader statuscode=404 statustext=Page not found CFABORT 2. in IIS I defined a URL to be called in case of error 404, this page displays a friendly message, then it also has to declare cfheader statuscode=404 statustext=Page not found (fortunately, IIS won't call the URL a second time, and loop) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359045 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Sort by file extension in CFDIRECTORY
I think you replied to the wrong thread there Ooops... sorry ;-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359046 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
