Updating Multiple Rows

[wilsonil]

I have a form that returns a query with several rows and columns to a cfform. I would like the ability to have the user update a quantity field on any or all of the rows and then hit an update button to update them. I can do them separately by putting an update button on each row, but I would like to eliminate the need to go back and forth between screens to update quantity values.

Any ideas? I am at a loss right now.

Thanks,

Wendy

[CF_Oracle]

Did you try to use cfgrid and cfgridupdate tags?

[Dan_Bracuk]

In your form, append something to the end of the field names to identify the record. Your fields would then have names like
abc1, abc2, abc3, def1, def2, def3, etc

When you process the page, you do something like this to get the values
<cfoutput>
<cfloop from = "1" to = "3" index = "ii">
#form.abc[ii]#
or something like that.

[furious70]

Like said above, cfgrid is now set up to do these types of operations, have a look in the documentation, I think you'll like.

[Newsgroup_User]

The problem with cfgrid is the fact it is a java applet.

--
Bryan Ashcraft (remove brain to reply)
Web Application Developer
Wright Medical Technologies, Inc.
=============================
Macromedia Certified Dreamweaver Developer
Adobe Community Expert (DW) :: http://www.adobe.com/communities/experts/


"furious70" <webforumsuser@macromedia.com> wrote in message
news:e3tkpm$oru$1@forums.macromedia.com...
> Like said above, cfgrid is now set up to do these types of operations,
> have a look in the documentation, I think you'll like.

[furious70]

looks like in the livedocs there's a bug a year old where it doesn't work with a flash form, but it's supposed to. Didn't dig around to see if that was fixed in 7.0.1

[suchil00]

I needed to do this some time ago - here's a good tutorial http://tutorial214.easycfm.com/

The only thing I changed is that I used the FORM structure to read the values instead of EVALUATE - which is know to increase overhead like so -
<cfset new_value = #Form["old_valuer" & count]#>