I am not sure how to ask the question, but here goes. I have a multiline survey storing data about a specific project. I want to store the data in the following fields:
proj_id
strat_issue
strat_goal
strat_obj
strat_value
here is an example of my code
<form action="strat_survey.cfm?update=gogo" method="post">
<table width="90%" border="1" cellpadding="3" cellspacing="0" bordercolor="#CCCCCC">
<tr>
<td colspan="3" align="center"><strong><font color="#0000FF">Project Alignment
with 2007-2010 STRATEGIC ISSUES, GOALS, AND OBJECTIVES</font></strong></td>
<td><font size="2"><strong>Project Aligns with Objective</strong></font></td>
</tr>
<tr>
<td colspan="3"><strong>Service Delivery - It is critical that we employ strategies
to ensure excellent service delivery.</strong></td>
<td> </td>
</tr>
<tr>
<td width="2%"> </td>
<td width="2%">1</td>
<td width="86%">Develop a comprehensive Customer Service Action Plan to enhance
the delivery of Department services.</td>
<td width="10%"> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td>1.1 Establish methods to continually assess internal and external customer
satisfaction.</td>
<td> <input type="checkbox" name="strat_value" value="1"> <input type="hidden" name="strat_issue" value="Service Delivery">
<input type="hidden" name="strag_goal" value="1"> <input type="hidden" name="strat_ob" value="1.1"></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td>1.2 Implement service level improvements to assist customers and improve
efficiency and effectiveness. (wait times, credit cards)</td>
<td> <input type="checkbox" name="value2" value="1"> <input type="hidden" name="strat_issue" value="Service Delivery">
<input type="hidden" name="strat_goal" value="1"> <input type="hidden" name="strat_obj" value="1.2"></td>
</tr>
</table>
This insert code only inserts the same value for all fields
<cfquery name="strat_post" datasource="#request.dsn#">
INSERT INTO proj_strat_align
(strat_issue,strat_goal,strat_obj,strat_value)
values
('#form.strat_issue#','#form.strat_goal#','#strat_obj#','#strat_value#')
</cfquery>
Thanks