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
Dawson, Michael wrote:
You have probably thought of all of these solutions, but I need to kill an hour before I can put the top down on the Vette and drag my ass home...
1. Convert to WDDX, do a regex replace 2. Insert into SQL database and query it back out 3. Build a new query object with the extra columns, then loop over this query and copy the data to the new query object.
I haven't tried it, but does QoQ support Left() or Right() rather than
Mid() or SubString()?
It seems with all the limitations of QoQ, it should have just been named "QueryResorter".
Mike
-- Peter J. Farrell :: Maestro Publishing
blog :: http://blog.maestropublishing.com email :: [EMAIL PROTECTED] phone :: 651-204-0513
OHNOSECOND-- That miniscule fraction of time in which you realize that you've just made a BIG mistake. --
---------------------------------------------------------- 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]
