I've not had luck using LIKE in CF 5 QofQ... > If you really needed the results in a single query, you > could retrieve ALL > the files and then do a "query of a query" using a > condition like this:
> WHERE Name LIKE '%.gif' > AND Name LIKE '%.jpg' > or possibly run cfdirectory twice - once for each > extension - and use the > query functions to merge the two result sets... > Gene Kraybill > -----Original Message----- > From: Randell B Adkins [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 11, 2002 3:46 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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~| > Archives: > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > Subscription: http://www.houseoffusion.com/index.cfm?sideb > ar=lists&body=lists/cf_talk > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Signup for the Fusion Authority news alert and keep up > with the latest news in ColdFusion and related topics. > http://www.fusionauthority.com/signup.cfm Isaac 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
