i am looping through theform and collecting survey answers, if i select
multiple answers they get inserted on one line how can i insert the value
individulay? How can i modify the code so i can make the code work the way i
need
<cfif isDefined("btnSubmitSurvey")>
<cfoutput>
<cfif isDefined("form.fieldnames")>
<CFLOOP LIST="#form.fieldnames#" Index="field">
<cfif #field# neq "btnSubmitSurvey">
<cfquery name="qryInsert" datasource="cfelsunrise" dbtype="odbc">
insert into answers (questionidfk,answer,empID,surveyID) values
(#ListLast(Evaluate("Form.#field#"),"_")#,'#Evaluate(field)#',#session.empID#,#url.survey#)
</cfquery>
<cfelse>
</cfif>
</CFLOOP>
</cfif>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:304580
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
