Hi Gordon,
Yeah, if there's a manageable number of files, with unique names, then I
pre-run the query to get the info about ALL files, and shove the data into
Author and Description structures, indexed by filename.
As you loop through the directory, you check the existence of the filename key
in the structures, and display the info if it exists.
With some thought, and depending on your particular situation, you can
optimise the cacheing and flushing of the query and the structures. A good
exercise, don't you think?
Best of luck,
Lee Bjork Borkman
Bjork.Net - ColdFusion Tags by Bjork
----------------------
Gordon Burns <[EMAIL PROTECTED]> wrote:
I have to create a list of files to Display.
Also want to add small descriptions and Author pulled from a
database that is updated when file is uploaded from a form.
However not all files will have an author and not all will have a
description.
In the table display of the files (which is created from the Dir
Listing not the database query) what recommendation do you have for
including the database info of Author and Description in the table
when they exist.
I have been considering creating a list, an array, evaluating in
the dir table output but I an not sure which is the best and most
efficient way to go about this?
I am sure others must have been down this route? Any and all
suggestions welcome.
Thanks
Gordon
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
