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
