Is this what you're looking for?
<cfquery datasource="dsn" name="qWhatever">
SELECT *
FROM tablename
</cfquery>
<cfoutput query="qWhatever">
<cfset FORM.ID="#ID#">
<cfset FORM.variable="newvalue">
<cfupdate datasource="dsn" tablename="tablename"
formfields="ID,variable">
</cfoutput>
Joshua Miller
Web Development
Eagle Technologies Group, Inc.
Business Solutions for the Next Generation
www.eagletgi.com
[EMAIL PROTECTED]
----- Original Message -----
From: "Tony Schreiber" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 5:30 AM
Subject: Re: Looping over form data?
> Dylan suggestion was one of two techniques I've used. You can name the
> fields dynamically using the ID of the record as a prefix:
>
> <INPUT NAME="ID" VALUE="12">
> <INPUT NAME="12_Address" VALUE="">
> <INPUT NAME="12_City"> VALUE=""...
>
> The other thing I've done is leave the names alone and use the fact that
> same-named variables will result in a comma separated list of values. So
> as long as you have an ID field (usually hidden) with a list of IDs, you
> can use ListFind and ListGetAt to pick all the values for that ID from all
> the fields. Two major caveats however with that method. 1) You can't have
> commas in the data and 2) Empty fields do not have a "placeholder" comma.
>
> I've never been able to get past #1 because there's no way to access the
> data (to replace commas) before it comes a formfield...
>
> > I need to pull a number of records at once from a database, edit them on
> > one page, then send the data back to the database. Looping over the
query,
> > I've been able to place the data correctly on the page.
> >
> > However, I'm at a loss as to how to update the edited records back into
the
> > database. I'm currently trying to post them as form data but it fails
> > because each record's input fields have the same name.
> >
> > Is there a way to loop over form data or to dynamically rename form
fields?
> > And/or is there a better way to edit multiple records at once than by
using
> > a form?
> >
> > Thanks for any help,
> > Les
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
