Here is an article from coldfusion cookbook.
select sum(size) as size from cfDir
#numberFormat(sizeMB,",.99")# Note the ‘recurse’ option, this will get the size of the current and all sub-directories. If you only need the size of the current directory, change recurse to false.