I imagine I'm not alone in having information (filesize, filetype, description, custom title, upload date, etc.) about files uploaded to a site stored in a DB table.
I'm creating a search interface, and I'm just wondering if there's any simple way in CF of including information from the DB about files in the collection when I index the files themselves. The only thing I can think to do is: - Name files that are uploaded with their ID on the end, like 'download_23.pdf' (which I do anyways) - Index the files - When the search results are output, grab the ID with ListLast(filename, "_"), perform a <CFQUERY>, and output the DB-stored info with each result This seems like overkill on the DB. I suppose if you limit the results to ten per page... But still, I'd rather not have ten extras DB hits for every search request. Is there are simpler way? - Gyrus ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
