pretty sure it's the other way around Shawn...1 record to many filenames ;-)
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: "Shawn Grover" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 10, 2002 2:05 PM Subject: RE: Concatanation (THANKS) > 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? > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
