Sorry, my list was a list of "separate" solutions. Not a 1, 2, 3. process where all steps are required.
I should have used <ul> instead of <ol>. ;^) M!ke -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter J. Farrell Sent: Friday, March 18, 2005 4:05 PM To: [email protected] Subject: Re: [CFCDev] OT: QoQ Substring? Maybe I'm missing something here, but couldn't you just: 1. "convert" the cfdirectory call into a newQuery() in CF not SQL 2. looping over the original cfdirectory query date with querySetCell() -parse out the data you don't need in the file name - put the date you want to sort by into another column 3. use QoQ on the new query object you just made It seems simpler than WDDX'ing it about with regex and using your DB as well. .pjf ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
