..? So? you can't roll your own?
===========================================
<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(getImages["NAME"][i],2,"."))#,i);
}
</cfscript>
<cfdump var="#myRealQuery#">
===========================================
Might seem like extra work, but ... 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.
~Todd
On Fri, 21 Jun 2002, S. Isaac Dealey wrote:
> > You do know you can do a query of queries on this, right?
> > right.
>
> That's what my example showed -- however -- query of query is
> case-sensitive, and doesn't allow you to use functions on columns or the
> LIKE keyword ( last I checked in CF 5 -- maybe dif. in CF MX ) ... so you'd
> have to determine which files are the ones you want manually -- create an
> array, apply the array as a new column, then use a query of query to
> eliminate the items you don't want.
>
>
> Isaac
>
> www.turnkey.to
> 954-776-0046
--
============================================================
Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion |
http://www.macromedia.com/support/forums/team_macromedia/ |
http://www.flashCFM.com/ - webRat (Moderator) |
http://www.ultrashock.com/ - webRat (Back-end Moderator) |
============================================================
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
