Getting a file list

[judson75]

I am trying to list files in a directory. It is a sub directory of where the script will run. I have the attached code, but it list in the current directory, I need it to look in the 2007_photos directory.

[Guest]

If you want to list files in a subdirectory of the current template path, you will have to specify the subdirectory:

<cfdirectory action="list"
directory="#getDirectoryFromPath(getTemplatePath())#/mySubdirectory"
name="currentDir">

[judson75]

worked great. now, say I want just the first file in the list? So I can display it as the main image?

[Newsgroup_User]

if you use <cfoutput>#queryname.columnname#</cfoutput> it will reference
the FIRST ROW of the query only. or explicitly request the first row
with #queryname.columnname[1]#. for a different row, substitute [1] with
appropriate row number.

hth


Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

[judson75]

I am very new to ColFusion, but is this for a database query? I am just trying to get a file name from a directory, or the file list loop created at the begining of this thread.

[Newsgroup_User]

<cfdirectory> returns a query object... read the docs.

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

[Newsgroup_User]

in your particular case you would use #currentDir.name[1]# to get the
first file returned by your <cfdirectory> query.

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

[judson75]

I was kind of thinking that. Thanks a bunch!

[stevenbeee]

Thanks, it worked for me!