Yet another time your tag comes in handy, we have a DBA that likes to get
his hands in CF. He has been told not to touch our source anymore. Now I
need a means of ensuring our dev environment matches our production
environment. In comes your tag to the rescue:
<cf_dp_filefind directory="C:\Inetpub\wwwroot\tim" recurse="Y"
extensionstofind="cfm,css,js,txt,sql" outputstyle="query"
outputquery="files">
<cfset hashedArray = arrayNew(2)>
<cfloop query="files">
<cffile action="read" file="#file#" variable="thisFile">
<cfset hashedArray[1][files.currentRow] = hash(thisFile)>
<cfset hashedArray[2][files.currentRow] = file>
</cfloop>
<cfset hashedQuery = queryNew("")>
<cfset temp = queryAddColumn(hashedQuery, "fileHash", hashedArray[1])>
<cfset temp = queryAddColumn(hashedQuery, "fileName", hashedArray[2])>
<cfdump var="#hashedQuery#">
> -----Original Message-----
> From: Jim Davis [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 17, 2006 1:05 PM
> To: CF-Community
> Subject: RE: Unique file extensions question
>
> > -----Original Message-----
> > From: Brian Simmons [mailto:[EMAIL PROTECTED]
> > Sent: Monday, July 17, 2006 12:35 PM
> > To: CF-Community
> > Subject: Unique file extensions question
> >
> > Anybody got a suggestion for this situation:
> >
> > I've got a folder that contains many other folders, and many files.
> > I would like to get a breakdown of the file extensions in the folder,
> i.e.
> > 5000 .MP3 files
> > 1000 .XLS files
> > 500 .GIF files
> > etc...
>
> Boy... making me dig through the vaults! ;^)
>
> This is a custom tag I wrote for CF 4.5 that will do what you're asking:
>
> http://www.depressedpress.com/Content/Development/ColdFusion/Extensions/DP
> _F
> ileFind/Index.cfm
>
> This will recurse over a given directory and return a query of all the
> files
> found (optionally returning only files of a specific extension list). You
> can then easily do a Query-of-Query to get the actual numbers or total
> sizes
> or whatever.
>
> Jim Davis
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:5/messageid:211307
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
