AHHHHHHHHHH!!!! I'm Melting!!!! I keep forgetting!! I wrote the code a LONG time ago and keep copying it (while forgetting to change it)!
I'm changing it NOW!!! ______________________________________________________ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: <mailto:[EMAIL PROTECTED]> Rockville, MD 20850-1299 WWW: <http://www.euservices.com> ______________________________________________________ > -----Original Message----- > From: Raymond Camden [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 17, 2002 8:15 AM > To: CF-Talk > Subject: RE: Looping though form fields for insert > > > Ack! No! Remember that yo udo not need to use evaluate to get form > fields! > > <cfloop item="field" collection="#form#"> > <cfoutput>Form.#field# is #Form[Field]#<br></cfoutput> > </cfloop> > > ===========================================================> ======== > Raymond Camden, Principal Spectra Compliance Engineer for Macromedia > > Email : [EMAIL PROTECTED] > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -----Original Message----- > > From: Bill Grover [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, January 17, 2002 7:42 AM > > To: CF-Talk > > Subject: RE: Looping though form fields for insert > > > > > > The following code will loop through all of the form fields > and set a > > variable to a comma delimited list of the titles. You can > > then use the > > variable for your insert. > > > > <CFSET lcSongList = ""> > > <CFLOOP INDEX="lcFieldName" LIST="#FORM.FieldNames#"> > > <CFIF LEN(lcSongList) GT 0> > > <cfset lcSongList = lcSongList + ","> > > </CFIF> > > <CFSET lcSongList = lcSongList + > > TRIM(EVALUATE("FORM.#lcFieldName#"))> > > </CFLOOP> > > > > Hope this helps. > > > > ______________________________________________________ > > > > Bill Grover > > Supervisor MIS Phone: 301.424.3300 x3324 > > EU Services, Inc. FAX: 301.424.3696 > > 649 North Horners Lane E-Mail: <mailto:[EMAIL PROTECTED]> > > Rockville, MD 20850-1299 WWW: <http://www.euservices.com> > > > > ______________________________________________________ > > > > > > > > > -----Original Message----- > > > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, January 16, 2002 10: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 > > > > > > > > ______________________________________________________________________ Get Your Own 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=coldfusionb 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
