ColdFusion

insert loop

Please support our ColdFusion advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2008

Posts: 2

Reputation: berlindeb is an unknown quantity at this point

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>

Thanks

Last edited by peter_budo; Apr 20th, 2008 at 7:52 pm. Reason: Keep It Organized - please use [code] tags

•

Join Date: Feb 2008

Posts: 72

Reputation: cmhampton is an unknown quantity at this point

Solved Threads: 10

cmhampton

Offline

Junior Poster in Training

Re: insert loop

Apr 19th, 2008

One thing to check is to cfdump the form structure and make sure that the data from the form is correct.

 Help with Code Tags 
 ColdFusion Syntax (Toggle Plain Text) 
  <cfdump var="#form#">
  <cfdump var="#form#">

Do you have any <cfset> statements that could be over-writing the value of those form variables? If possible, please post the entire strat_survey.cfm page so we can look at it more thoroughly.

Thanks

•

Join Date: Apr 2008

Posts: 2

Reputation: berlindeb is an unknown quantity at this point

Solved Threads: 0

berlindeb

Offline

Newbie Poster

Re: insert loop

Apr 21st, 2008

Here are the results from the CFDUMP
struct
FIELDNAMES STRAT_VALUE,STRAT_ISSUE,STRAG_GOAL,STRAT_OBJ,VALUE2,STRAT_GOAL
SEARCHSTRING [empty string]
STRAG_GOAL 1
STRAT_GOAL 1
STRAT_ISSUE Service Delivery,Service Delivery
STRAT_OBJ 1.1,1.2
STRAT_VALUE 1
VALUE2 1

Here is how the data was stored

recnum; 22
recdate: 04/21/2008
blog_id:
strat_issue: Service Delivery,Service Delivery
strat_goal: 1
Strat_obJ: 1.1,1.2
strat_value: 1

I need it to update two records, like this

1.
recnum 1
recdate 04/21/2008
blog_ID
strat_issue Server Delivery
strat_goal 1
strag_obj 1.1
strat_value 1

2.
recnum 1
recdate 04/21/2008
blog_ID
strat_issue Server Delivery
strat_goal 1
strag_obj 1.2
strat_value 1

•

Join Date: Feb 2008

Posts: 72

Reputation: cmhampton is an unknown quantity at this point

Solved Threads: 10

cmhampton

Offline

Junior Poster in Training

Re: insert loop

Apr 24th, 2008

I'll have a look at it tomorrow and see if I can help.

•

Join Date: Oct 2005

Posts: 8

Reputation: jamba is an unknown quantity at this point

Solved Threads: 1

jamba

Offline

Newbie Poster

Re: insert loop

May 1st, 2008

At first glance - looks like you have a typo:

 Help with Code Tags 
 ColdFusion Syntax (Toggle Plain Text) 
<input type="hidden" name="strag_goal" value="1"> <input type="hidden" name="strat_ob" value="1.1">
<input type="hidden" name="strag_goal" value="1"> <input type="hidden" name="strat_ob" value="1.1">

name="strat_obj" ??

Last edited by jamba; May 1st, 2008 at 9:14 am.

•

Join Date: Jun 2008

Posts: 10

Reputation: iqbalhosan is an unknown quantity at this point

Solved Threads: 0

iqbalhosan iqbalhosan is offline

Offline

Newbie Poster

Re: insert loop

Jun 3rd, 2008

you have done a lot of mistakes. forward your pages to me.

•

Join Date: Jul 2008

Posts: 2

Reputation: soolmaan is an unknown quantity at this point

Solved Threads: 0

soolmaan

Offline

Newbie Poster

Re: insert loop

Jul 18th, 2008

 Help with Code Tags 
 ColdFusion Syntax (Toggle Plain Text) 
('#form.strat_issue#','#form.strat_goal#','#strat_obj#','#strat_value#')
('#form.strat_issue#','#form.strat_goal#','#strat_obj#','#strat_value#')

Why are you using 'form.value' and 'value' beter to just use al with form.xx

like :

 Help with Code Tags 
 ColdFusion Syntax (Toggle Plain Text) 
('#form.strat_issue#','#form.strat_goal#','#form.strat_obj#','#form.strat_value#')
('#form.strat_issue#','#form.strat_goal#','#form.strat_obj#','#form.strat_value#')