Before you settle into a solution, what type of files are you talking about?
I have solved this a couple of different ways. 1. Directories of htm and cfm and pdf files. I embedded extra tags in a comments section at the top of the file. <bangdashdash <DESCRIPTION>Description Goes Here</DESCRIPTION> <TEASER>This is the short line of text to display on listing pages</TEASER> <ISSUEDATE>Jan 13, 2003</ISSUEDATE> dashdash> Then used Verity to search and retrieve these fields from the files, inlcuding path, URL, and these extra FIELDS. 2. Married each file with an info file stored in the same directory with the same name but extra extension. Jerry.jpg Jerry.jpg.nfo or Jerry.jpg.txt or Jerry.jpg.xml And then place all the "extra" info into that file. Easy to find. Easy to see when missing. 3. For those files with short simple desc, just add the desc to the filename or directory name. MA20030317_News Story_Boy Bitten By Dog.htm Just some ideas, Jerry Johnson >>> [EMAIL PROTECTED] 03/24/03 08:23PM >>> That may work...I think.....have you got an example of that code? ----- Original Message ----- From: "Philip Arnold" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 2:21 PM Subject: RE: Automatic File List in Database > > The file list holds images and drawings, which need > > descriptions in another field in order to be selected. There > > are thousands of files and the files have strange naming > > conventions. Best I can figure, I need a field with paths and > > a field with descriptions, so I can call them up and display > > them in the page. I tried using CFDIRECTORY, but describing > > the files is the main thing. > > If the description isn't always going to be there, then why not have the > location and file name, plus the description in the database, that way > you can reference it for those that it "needs" > > Then use a Query of Query to join the CFDIRECTORY result to the > information in the database > > Would that work? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
