CF_Jazz

I’m frequently building dashboard tools, and this is a handy and simple trick.  It basically uses CFDIRECTORY to build a query, and then queries the query for Type = ‘File’.  I just ask for a COUNT in the second QUERY, since I’m not really interested in the other data and like to keep things fast.

Here’s the code as a handy function that you can drop into a component.

<cffunction name="fileCount" returnType="numeric" output="false">

<cfargument 	name="folderLoc" 		required="no">
<cfparam 			name="folderLoc" 		default="">

<cfdirectory directory="#folderLoc#" action="list" recurse="true" name="getAllFolders">

<cfquery 
	name			="examineThis" 
	dbtype		="query"
	>
  SELECT    COUNT(*) AS NumberOfFiles
  FROM    	getAllFolders
  WHERE    	Type = 'File'
</cfquery>

<cfreturn #val(examineThis.NumberOfFiles)#>

</cffunction>