>
> ..? So? you can't roll your own?
>
[deletia]
> 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.
Err, why not just do it here:
<cfquery name="getImages" dbtype="query">
SELECT NAME,DATELASTMODIFIED,[SIZE] from wpahs_images
where
lower(Name) LIKE '%#Type#'
</cfquery>
where Type is ".gif". Here is a full sample from mastering cfmx:
<CFSET Types = ".cfm,.html,.htm">
<CFSET Directory = "d:\cfusionmx\wwwroot\cfdocs">
<CFDIRECTORY ACTION="List" DIRECTORY="#Directory#" Name="Files">
<CFQUERY NAME="GetWebFiles" DBTYPE="Query">
SELECT Name
FROM Files
WHERE Type = 'File'
AND (
1=0
<CFLOOP List="#Types#" INDEX="Type">
OR lower(Name) LIKE '%#Type#'
</CFLOOP>
)
</CFQUERY>
=======================================================================
Raymond Camden, ColdFusion Jedi Master for Macromedia
Email : [EMAIL PROTECTED]
Yahoo IM : morpheus
"My ally is the Force, and a powerful ally it is." - Yoda
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
