insert loop

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ColdFusion section within the Web Development category of DaniWeb, a massive community of 374,153 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,449 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ColdFusion advertiser:

Thread Tools Display Modes

Views: 1721 | Replies: 6

Previous Post in Thread

Next Post in Thread

•

Join Date: Apr 2008

Posts: 2

Reputation: berlindeb is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

berlindeb

Offline

Newbie Poster

insert loop

Apr 18th, 2008

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

 Help with Code Tags 
 html Syntax (Toggle Plain Text) 
<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>&nbsp;</td>
  </tr>
  <tr> 
    <td width="2%">&nbsp;</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%">&nbsp;</td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td>&nbsp;</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>&nbsp;</td>
    <td>&nbsp;</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>
<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>&nbsp;</td>
  </tr>
  <tr> 
    <td width="2%">&nbsp;</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%">&nbsp;</td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td>&nbsp;</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>&nbsp;</td>
    <td>&nbsp;</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

 Help with Code Tags 
 coldfusion Syntax (Toggle Plain Text) 
<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> 
<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> 