You can also just use my Form Utilities component ( http://formutils.riaforge.org/) to automatically translate array or structure notation into complex data structures on the server side. So it would become:
<cfoutput query="userQuery"> <input name="user[#currentRow#].userID" value="#userID#" /> <input name="user[#currentRow#].firstName" value="#firstName#" /> <input name="user[#currentRow#].lastName" value="#lastName#" /> </cfoutput> And on the server you get back an array of structures. So assuming the query had 3 rows, you'd get an array named "user" with three elements. Each element would be a structure with keys of userID, firstName, and lastName, with the appropriate values. It beats the heck out of trying to parse out numbers from field names! :-) On Tue, Jul 15, 2008 at 7:14 AM, Richard Cooper <[EMAIL PROTECTED]> wrote: > Hi All, > > Having brain freeze on this... Basically have a form, part of the form is > populated from a query within an unknown number of field elements. > > The form code snippet would look something like this. > > <cfoutput query="someQuery"> > <input name="anID#currentRow#" value="#anID#" /> > <input name="someField#currentRow#" value="#someFieldValue#" /> > <input name="otherField#currentRow#" value="#otherFieldValue#" /> > </cfoutput> > > I want to be able to take the form and run either update or creates for the > form. How would I go about referencing the form fields to insert/update my > DB? > > Thanks, > > R > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309124 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
