LiveDocs Comments - coldfusion - 6.1 - htmldocs - tags-a20.htm

coldfusion/6.1/htmldocs/tags-a20.htm

2006-02-14T10:43:26

http://www.easycfm.com/forums/viewmessages.cfm?Forum=12&Topic=8733

For those of you that cannot create directories on remote servers. Very helpful.

coldfusion/6.1/htmldocs/tags-a20.htm

moneybagsxp — 2005-10-04T11:55:59

Yep, you nailed it.
For a directory containing .PDF, .HTML, and .TXT, the below DOES NOT include .PDF, but does .HTML and .TXT

action="list"
directory="#CGI.document_root##APPLICATION.absPath#/reports/"
name="pdfFiles"
filter="*.html|*.txt"
sort = "datelastmodified"
>

coldfusion/6.1/htmldocs/tags-a20.htm

2005-09-07T07:52:19

[quote] How can I define more than 1 filter in cfdirectory? I need to filter several filetypes, *.xls, *.doc, *.htm and others. Will this statement work? FILTER="*.*" Any other ideas? [/quote]

coldfusion/6.1/htmldocs/tags-a20.htm

mxstu — 2005-07-15T09:04:44

Apparently "Size" is a reserved word for queries http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/express4.htm

Even though CFDIRECTORY returns a column named "Size" it doesn't seem like you can include the column by name in a Q of Q.

coldfusion/6.1/htmldocs/tags-a20.htm

mxstu — 2005-07-15T05:19:34

I tried the multiple filter code suggested by No Screen Name, and it worked fine until I tried to specify the column names. The Q of Q UNION worked fine until I included the "Size" column.

SELECT Attributes, DateLastModified, Mode, Name, Type, Size
FROM TXTList
UNION
SELECT Attributes, DateLastModified, Mode, Name, Type, Size
FROM XLSList
ORDER BY NAME

Returns error

Error Executing Database Query.

Query Of Queries syntax error.
Encountered "Size" at line 0, column 0. Incorrect Select List, Incorrect select column,

coldfusion/6.1/htmldocs/tags-a20.htm

jrunrandy — 2005-07-05T11:28:02

Shobna. I'm sorry. I can't think of a workaround for this. You might try posting your question to the online forums. http://webforums.macromedia.com/coldfusion. One of the people who monitor the forums may have a creative workaround.

coldfusion/6.1/htmldocs/tags-a20.htm

shobna — 2005-06-10T11:31:50

If cfdirectory tag is turned off in the cf administrator (because of security issues), how do I get the names of the files I need to retrieve for my application?

coldfusion/6.1/htmldocs/tags-a20.htm

2005-05-10T13:32:02

For those looking to filter multiple file types, try this:

SELECT * FROM JPGList
UNION
SELECT * FROM GIFList
ORDER BY NAME

That should work.

coldfusion/6.1/htmldocs/tags-a20.htm

Pim.Man — 2005-04-13T06:27:07

I have a better redundancy solution ;) (at least on Windows)

Cheers
/pim

coldfusion/6.1/htmldocs/tags-a20.htm

jfine — 2005-04-03T15:15:44

Found a strange but very handy way to move a folder, subfolders, and all files within the folder. Using cffile, not cfdirectory, and using a folder name as source:

source = "#foldername#"
destination = "#destname">

At least on windows2003, it moves the folder and everything in it. Good for me, hope that doesn't change.

coldfusion/6.1/htmldocs/tags-a20.htm

webdev101 — 2005-01-27T15:25:18

since the function to destroy a directory even if it contains files and folders posted priously, had some hardcoded and redundant stuff, i had to code my own: hope it helps someone:

USE

coldfusion/6.1/htmldocs/tags-a20.htm

mindtrap — 2005-01-25T11:55:28

I ran into a major problem lately where returns the following value in the column: datelastmodified = 'January 25, 2005 2:28:57 o'clock PM EST'.

First of all where the heck does the "o'clock' come from and why does IsDate return Yes, but all other date functions fail on this data?

coldfusion/6.1/htmldocs/tags-a20.htm

scrapbox — 2004-11-10T16:14:21

Ive been working with cfDirectory and in addition to the problem with modified dates, I've have noticed the filter behavior has changed.

In coldfusion 5 i was using cfDirectory with filter="*." to list only the directories, like this...

[blah]

That worked great in 5 but in MX it returns an empty record set.

Now i have list everything and check the type when im looping through it, like this right?...

[blah]

Its a lot slower now because most of the directories im dealing with here have maybe hundreds of files but only few directories. Being able to filter out all the files and just deal with the dirs was substantially faster. It'd be great if that functionality returned some day.

coldfusion/6.1/htmldocs/tags-a20.htm

dp168 — 2004-11-08T12:43:17

When I use cfdirectory to return the server file time stamp, datelastmodified is returning an adjusted time to account for DST. Is there a way to return the time as is?

coldfusion/6.1/htmldocs/tags-a20.htm

whazaah — 2004-09-30T03:22:27

Is there someone who nows if you can limit the resultset of a cfdirectory (list)? I need just 1000 files of a directory with about 100000 files in it. It slows down the process very hard to list all 100000 with the cfdirectory tag and then loop over the first 1000 of it.

coldfusion/6.1/htmldocs/tags-a20.htm

Ernesto RA — 2004-09-03T07:32:15

The ? character in the file parameter didn't seems to work. When I tried to use it, CF throws a "Error: ?+* follows nothing in expression null". It seems that it's taking the filter parameter as a regular expression?

coldfusion/6.1/htmldocs/tags-a20.htm

grndvl1 — 2004-08-24T08:04:59

Just a quick question. When I am using CFdirectory the application is running in c:/wwwroot/application/hthml. I need CFdirectory to look at a root folder on the webserver C:/wwwroot/images/home. I am testing on a windows server but the problem comes when I go to deploy this live on a Linux server. Since the directory requires absolute path how do I do this dynamically?

coldfusion/6.1/htmldocs/tags-a20.htm

thewickedone — 2004-08-14T05:22:36

since the function to destroy a directory even if it contains files and folders posted priously, threw me some errors, i had to code my own: hope it helps someone:

name="delfile"
directory="C:\CFusionMX\wwwroot\#arguments.dir##arguments.sdir#">
AND delfile.RecordCount EQ 0>

directory="#dirtodel#">

file="C:\CFusionMX\wwwroot\#arguments.dir##arguments.sdir#\#name#">

directory="#dirtodel#">

coldfusion/6.1/htmldocs/tags-a20.htm

halL — 2004-08-11T11:40:25

In respose to hereticmessia:
This issue should be resolved in the next major release of ColdFusion MX.
In the meantime, you could try the following custom function in place of LSParseDateTime to workaround the issue:

coldfusion/6.1/htmldocs/tags-a20.htm

hereticmessiah — 2004-08-10T11:38:12

Consider this, kids:

You're a developer sitting in some country whose locale isn't on JRun's list. For the most part, this is fine: you deal with dates in UTC or, if it doesn't matter, without caring what the timezone is.

Then you try and list a directory using CFDIRECTORY and assume that the dates you get from that are *real* date objects (i.e. {ts 'blah blah'}). To your surprise, they're not, but are ones formatted for the current locale.

No problem, you think, I'll just run this through LSParseDateTime(). But no joy: you're told it's not a valid date.

Then you try plain old ParseDateTime(), but *that* tells you that it doesn't support the en_IE (I'm in Ireland) locale. Now, this beggars belief.

So, what's a lad to do: he's working with a tag the spits back dates in an obviously flawed format and parsing functions unable to parse dates produced by another part of the product.

And no, switching from IST to BST isn't an option. I've tried that and the blasted thing is *still* spitting back bad dates. Right now, I'd like to clobber the programmer who wrote this code with a very big stick.

coldfusion/6.1/htmldocs/tags-a20.htm

_187 — 2004-07-19T06:27:02

I need the cfdirectory function returning the files ordered by file name but case insensitive. Is it possible just with the cfdirectory tag ?
I'm under CF 5.0 Linux
Thx

coldfusion/6.1/htmldocs/tags-a20.htm

2004-07-12T14:49:54

My bad. I was so used to cf 5.0 I was using startrow in the cfoutput to eliminate . and ..
Sorry.

......

coldfusion/6.1/htmldocs/tags-a20.htm

2004-07-12T14:37:32

When attempting to use the list function in cfdirectory (in CFMX 6.1) with NO directory filter, the list does not contain either the first 2 files in the directory when sort = "name asc" or the last two files when sort="name desc". This also happens when no sort is applied (see sort-"name asc")

Is this a known bug? Is there a HotFix?

coldfusion/6.1/htmldocs/tags-a20.htm

halL — 2004-07-12T07:39:24

The behavior depends on the operating system and how it resolves the path and determines permissions.
I believe the issue is that when you use the mapped drive, Windows uses the wide-open permissions.
When you use the IP address, you are probably short-circuiting the Windows sharing mechanism and its permission settings.
For further information, I suggest posting your issue to the online forums: http://webforums.macromedia.com/coldfusion/.

coldfusion/6.1/htmldocs/tags-a20.htm

2004-07-11T21:36:38

Thank you "halL said on Jul 7, 2004 at 8:23 AM ".

After changing the ColdFusion MX service to have higher permissions the IP address started to work. (Not really what I wanted though due to security concerns)

However, my initial testing with the service configured with "Local System" I got the following results:

I setup a share with share permissions Everyone Full Control and NTFS permissions Everyone Full Control. There were two text files in the share inheriting the same permissions.

I wasn't able to display the directory list using the IP address to connect.

I was able to display the directory list using a name to connect (I added the name and IP address to the local hosts file for name resolution).

Can someone verify this behaviour?

coldfusion/6.1/htmldocs/tags-a20.htm

halL — 2004-07-07T08:23:46

In response to No Screen Name of July 6 2004:
You can use an IP address, as in the following example:

Remember that ColdFusion must be running in a process with remote access permissions.
By default, if you run ColdFusion MX as a service in Windows, it runs under the local system account which lacks such permissions, as described in the note on this page.

coldfusion/6.1/htmldocs/tags-a20.htm

2004-07-06T21:54:58

cfdirectory in MX 6.1 doesn't support using an IP Address for a remote directory: "\\[IP Address]\Share\Directory"
eg \\123.123.123.123\myshare\mydirectory
This used to work in ColdFusion 5. I haven't been able to find any documents that list this as a change yet. Can someone confirm this?

How are names resolved by the cfdirectory tag for remote computers?

coldfusion/6.1/htmldocs/tags-a20.htm

2004-06-30T22:43:36

How can I define more than 1 filter in cfdirectory? I need to filter several filetypes, *.xls, *.doc, *.htm and others. Will this statement work? FILTER="*.*" Any other ideas? I need to resolve this for work so ANY prompt response is GREATLY appreciated!!!

coldfusion/6.1/htmldocs/tags-a20.htm

nk151 — 2004-06-07T09:46:38

On Windows, with MX 6.1, a call to CFDIRECTORY without an absolute path will create directories under the CFusionMX\runtime\bin directory, not the directory of the current template (just in case you're wondering where it went!).

coldfusion/6.1/htmldocs/tags-a20.htm

dnimmich — 2004-04-25T09:59:04

@ Santa Rosa Mike: This is not really a ColdFusion related problem but a Windows thing. You need to change the properties of the ColdFusion service, to be more precise: the account the ColdFusion MX Application service runs with. Unfortunately, Microsoft changes the way how to do this in every new Windows version and I only have a German one (which likely doesn't help you), so it is probably the best if you ask your local Windows guru how to run a service with a different user account. (And don't forget to tell him what Windows version you are running.)