one minor flaw with that routine.... you are limited to one record per file. If you need to associate multiple records to a single file, or a single file to multiple records, then you will need a cross reference table (i.e. FileID, RecordID)
But even worse yet, if your file can be associated with multiple records in multiple tables (where a file can be referenced from an image table, and a download table for instance), then you need include a table pointer of some sort: (i.e. FileID, TableName, RecordID) HTH Shawn Grover -----Original Message----- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 2:48 PM To: CF-Talk Subject: RE: Concatanation (THANKS) THANKS!! Went with that route. Much easier than what I was trying to attempt. -----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 3:43 PM To: CF-Talk Subject: Re: Concatanation I would have an extra table to associate files uploads with the record (i.e. Filename_ID,record_ID, filename). For each upload grab the name of the file uploaded (server.file if memory serves) and store it in the new table along with the record_ID in question. Then to display lateer you can just grab all filenames associated with a given record ID. HTH Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "James Taavon" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 10, 2002 12:36 PM Subject: Concatanation > Is it possible to concatenate multiple file uploads within the same field in > a database in order to list all files uploaded for a particular record? How > would it be done? > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
