> 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4