Yeah - I'm just trying to avoid that loop :) I think I'm stuck with it for now though.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter J. Farrell Sent: Friday, March 18, 2005 5: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 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] ---------------------------------------------------------- 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]
