Have you tried dumping the contents of "form.fieldnames" -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell)
-----Original Message----- From: erik tom [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 30, 2008 7:09 AM To: CF-Talk Subject: cflloop over the form. I am trying to gather the result of the survey. so when i click on the submit button I wanto collect the values from the entire form that were checked . Instead i get passed all the id rather than id that was checked <CFLOOP LIST="#form.fieldnames#" Index="field"> <cfif isDefined("form.fieldnames")> <cfquery name="qryInsert" datasource="cfelsunrise" dbtype="odbc"> insert into answer (answer,empID) values (#evaluate(field)#,#session.empID#) </cfquery> </cfif> </CFLOOP> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304486 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
