Re: Sort by file extension in CFDIRECTORY

2014-07-31 Thread Nick Voss
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

Re: Sort by file extension in CFDIRECTORY

2014-07-31 Thread Dave Watts
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

RE: Sort by file extension in CFDIRECTORY

2014-07-30 Thread Robert Harrison
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

Re: Sort by file extension in CFDIRECTORY

2014-07-30 Thread Nick Voss
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

Re: Sort by file extension in CFDIRECTORY

2014-07-30 Thread Dave Watts
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

Re: Sort by file extension in CFDIRECTORY

2014-07-30 Thread Claude Schnéegans
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

Re: Sort by file extension in CFDIRECTORY

2014-07-30 Thread Andrew Scott
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:

Re: Sort by file extension in CFDIRECTORY

2014-07-30 Thread Claude Schnéegans
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: