I think you misunderstood. I will type into a form 14 song titles each with their own form field.
IE: song1 song2 song3 song4 I then need to submit this to a insert query where there is only one column for song titles. If this is not clear just let me know There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown ----- Original Message ----- From: "Andrew Scott" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 16, 2002 7:08 PM Subject: RE: Looping though form fields for insert > <cfset songtitle=""> > > <cfloop query="queryname"> > <cfset songtitle="#SongTitle#,#queryanme.SongTitle#"> > </cfloop> > > The insert that into the field > > > -----Original Message----- > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 17 January 2002 2:12 PM > To: CF-Talk > Subject: Looping though form fields for insert > > I have 14 fields that hold the values of song titles, I need to insert > these into one column on insert. How can I accomplish this? Each song > title is associated with a album ID > > > > There are two major products that come out of Berkeley: LSD and [Unix] > BSD. We don't believe this to be a coincidence. > > > > Doug Brown > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
