LiveDocs Comments - coldfusion - 6 - CFML_Reference - Tags-pt121.htm

coldfusion/6/CFML_Reference/Tags-pt121.htm

tobylaroni — 2005-05-18T10:58:28

IMPORTANT NOTE (esp. important for coders using Fusebox):
If you are inside a loop (using cfoutput or cloop) of a query generated by CFDIRECTORY, you *cannot* use the attributes scope! This is because within the loop. "attributes" is the name of one of the fields returned by CFDIRECTORY. If you're in a CFDIRECTORY loop and you try to set the value of, say, attributes.person_id, you will encounter genuinely odd errors like:

You have attempted to dereference a scalar variable of type class coldfusion.sql.QueryColumn as a structure with members.

or

The value "person_id" cannot be converted to a number.

SOLUTION: a) don't use the attributes scope within the loop. b) if you need to use the attributes scope, either use QueryNew to construct a query using the results from CFDIRECTORY, or use Query of a Query and only pull in the name, datelastmodified, and type fields (for some reason, you can't retrieve the size field when doing a query of a query). Then, loop through this constructed query.

coldfusion/6/CFML_Reference/Tags-pt121.htm

ReganEngamn — 2004-01-09T17:03:17

Well cfdirectory used to do what I wanted it to and now it doesn't. I want to list the files dynamically in the current directory...
to bad you can't use "." or ".." in for the directory attribute

coldfusion/6/CFML_Reference/Tags-pt121.htm

sean9999 — 2003-09-23T12:20:46

it would be nice to know how to use the 'filter' attribute to EXCLUDE certain files or file types.

For instance, if i wanted to list all the files in a directory that WERE NOT .CFM files, or were not specifically application.cfm, heaeder.cfm (or whatever)...

One could of course filter them out after the fact during the cfoutput block, but it would be preferable to do it at the beginning

coldfusion/6/CFML_Reference/Tags-pt121.htm

Alex Peterson — 2003-08-18T11:43:52

ac: ascending (a to z) sort order is a typo. It should be "ASC" for ascending order.

coldfusion/6/CFML_Reference/Tags-pt121.htm

hlichtin — 2003-01-28T15:31:00

A quick test shows cfdirectory working with UNC and mapped drives, but that you have to be careful that you have the correct access permissions. When I ran CFMX as a Windows Service, I wasn't getting any results when I used cfdirectory to list a remote directory because CFMX runs as System and Windows file sharing wasn't allowing access to System.

coldfusion/6/CFML_Reference/Tags-pt121.htm

aeverett — 2002-08-26T19:54:00

It seems that CFDIRECTORY can't work with mapped network drives or even UNC mappings.