> ..? So? you can't roll your own?
.. that's what I thought I had described basically...
> ===========================================
> <cfdirectory action="LIST"
> directory="E:\stuff\cgh\cgh_files" name="wpahs_images">
> <cfquery name="getImages" dbtype="query">
> SELECT NAME,DATELASTMODIFIED,[SIZE] from wpahs_images
> </cfquery>
> <cfscript>
> myRealQuery =
> queryNew("name,date_last_modified,file_size,file_ext");
> queryAddRow(myRealQuery,getImages.recordcount);
> for(i=1;i lte getImages.recordcount;i = i + 1){
> querySetCell(myRealQuery,"name",#getImages["NAME"][i]#,i)
> ;
> querySetCell(myRealQuery,"date_last_modified",#getImages[
> "DATELASTMODIFIED"][i]#,i);
> querySetCell(myRealQuery,"file_size",#getImages["SIZE"][i
> ]#,i);
> querySetCell(myRealQuery,"file_ext",#ucase(getToken(getIm
> ages["NAME"][i],2,"."))#,i);
> }
> </cfscript>
> <cfdump var="#myRealQuery#">
> ===========================================
> Might seem like extra work, but ...
Seems to me like 6 of one or 1/2doz. of the other... In both cases you're
still looping through the cfdirectory query to manually generate the
information that was needed...
> hell, right there it is. Grab it and use it and do whatever
> you want with it. Now you can say things like
> select * from myRealQuery where file_ext NOT IN
> ('js','gif'), etc.
afaik qofq in CF 5 still doesn't allow the use of IN or NOT IN keywords...
like I say, maybe dif. in CF MX... but ultimately it wasn't my problem to
begin with, I was just offering a suggestion...
Isaac
www.turnkey.to
954-776-0046
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
