Thanks,
That is what I'm currently doing, was hoping to break out the directory
calls by file type (images/non-images) and then just refer to the
recordset I needed.

Guess I'll have to leave it this way.

Scott

-----Original Message-----
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] 
Sent: Friday, October 11, 2002 3:02 PM
To: CF-Talk
Subject: Re: Multiple filters on cfdirectory


> Only one filter can be applied.

> You can do a check on the extension of the file and if it does not 
> match your criteria, do nothing, else display the file name and such.



>>>> [EMAIL PROTECTED] 10/11/02 02:38PM >>>
> Is there a way to achieve the following (multiple filters), it does 
> not seem to work this way:

> <cfdirectory action="LIST" directory="#GetFullDir#" name="ImgList" 
> filter="*.gif, *.jpg" sort="Name, Type">

> TIA,
> Scott

There's a way to simulate it if you're using CF 5 or MX ... Try putting
this in a custom tag and using the ct to call your cfdirectory ...

<cfdirectory action="list" directory="#getfulldir#" name="giflist"
filter="*.gif" sort="name"> <cfset upper =
listtoarray(ucase(valuelist(giflist.name)))>
<cfset temp = QueryAddColumn(giflist,"upper",upper)>

<cfdirectory action="list" directory="#getfulldir#" name="jpglist"
filter="*.jpg" sort="name"> <cfset upper =
listtoarray(ucase(valuelist(jpglist.name)))>
<cfset temp = QueryAddColumn(jpglist,"upper",upper)>

<cfquery name="imglist" dbtype="query">
        select * from giflist union
        select * from jpglist
        order by upper
</cfquery>

The queryaddcolumn() is to allow for CF 5 case-sensitive sorting to sort
the QofQ in a case-insensitive maner. Of course -- this code is long
enough that you'd probably get more mileage out of a custom tag which
would take in the directory name and your desired multi-extension filter
list. The filter list would then be used to create an array of
<cfdirectory> queries to union within the query of query, and that way
you could specify as many and whatever type of filters you wanted, plus
it's portable code, so you can drag it around wherever you want it.

hth

S. Isaac Dealey
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Reply via email to