Right. -----Original Message----- From: Todd [mailto:[EMAIL PROTECTED]] Sent: 21 June 2002 11:38 To: CF-Talk Subject: RE: How can i filter more than one file type in cfdirectory
You do know you can do a query of queries on this, right? right. At 09:28 AM 6/21/2002 +0100, you wrote: >What about doing one cfdirectory call, and something like: > ><cfoutput query="dir"> > <cfif Right(name,3) eq "jpg" OR Right(name,3) eq "gif"> > #name# > </cfif> ></cfoutput> > >Ian > >-----Original Message----- >From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] >Sent: 20 June 2002 23:32 >To: CF-Talk >Subject: Re: How can i filter more than one file type in cfdirectory > > > > i need to filter for jpg's AND gif's in <cfdirectory > > filter anyone know how i can do this?? > >afaik there's not any way to do it naturally, i.e. with a single cfdirectory >call... if you need the list of them in alpha order, odds are you'll have to >do some tinkering... Something like this may work in CF 5: > ><cfdirectory action="list" name="rsimg" > sort="name" directory="#expandpath('images')#"> > ><cfset imgarray = ArrayNew(1)> > ><cfloop query="rsimg"> > <cfif rsimg.type is "file" and > ListFindNoCase("gif,jpg,jpeg",listlast(rsimg.name,"."))> > <cfset temp = ArrayAppend(imgarray,1)><cfelse> > <cfset temp = ArrayAppend(extarray,0)></cfif> ></cfloop> > ><cfset temp = QueryAddColumn(rsimg,"isimg","imgarray")> ><cfquery name="rsimage" dbtype="query"> > SELECT * FROM rsimg WHERE isimg = 1 ></cfquery> > >And at this point the query "rsimage" will hold the info you want. > >hope this helps, > >Isaac > >www.turnkey.to >954-776-0046 > > > ______________________________________________________________________ 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
