SQL Update Within Loop Not Working : Coldfusion, SQL

Experts Exchange

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

SQL Update Within Loop Not Working

Asked by firstheartland in ColdFusion Studio, Cold Fusion Markup Language, SQL Query Syntax

Tags: Coldfusion, SQL

OK.

I'm trying to loop through a set of results from a database and then apply apply a formula and update the records. I'm pretty sure that this WAS WORKING before and now is not. The SQL Statements are valid and work if I copy and paste them direct into the database. They seem to not be executing within the loop (which is the big time saver for the data entry person)

I receive no error message.

Get your answer NOW

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:

           
           
             <cfloop query="MarginToAdjust" >
                
					<!--- Calculate Bonus  ---->
                    <cfif (MarginToAdjust.Gross -  MarginToAdjust.StreetDirect) GTE arguments.maximum>
                    	<cfset newbonus = arguments.normalBonus>
                    <cfelse>
                    	<cfset newbonus = (arguments.percentage / 100) * (MarginToAdjust.Gross - MarginToAdjust.StreetDirect) > 
                        <cfset newbonus = int(newbonus)>
                    </cfif>
 
                    <cfquery name="update" datasource="ComSched" result="result">
                        UPDATE    AgentPayout
                        SET              Bonus = #newbonus#
                        WHERE     (PayoutID = #MarginToAdjust.PayoutID#)                        
                    </cfquery>
					<cfoutput>
					<tr>
                    	<td colspan="9"><cfdump var="#result#"> </td>

           
         

Attachments:

someTime.JPG (16 KB) (File Type Details)

Perhaps Executed

zeroTime.JPG (15 KB) (File Type Details)

Zero Execution Time

Related Solutions

Keywords: SQL Update Within Loop Not Working

	Title
1	Reverse Pivot Code Modification to incl…
2	Expertise on Making Queries with a Se…
3	Out of points - Access Export to Multi…

Loading Advertisement...

20091111-EE-VQP-89 - Hierarchy / EE_QW_3_20080625

Hall of Fame

1. azadisaryev278,860
2. gdemaria126,525
3. _agx_119,975
4. duncancu...80,740
5. SidFishes69,474
6. srikanthm...35,000
7. Jones91131,080
8. Zvonko20,050
9. erikTsomik18,928
10. dgrafx12,000
11. myselfran...11,080
12. pravinasar9,700
13. Tomarse...9,100
14. zadoc8,800
15. Mr_Nil6,400
16. mwvisa16,100
17. Plucka5,350
18. eszaq5,195
19. galadore4,760
20. clickitysplit4,050
21. usachrisk...4,000
22. js_vaughan3,800
23. mplungjan3,700
24. MartinCMS3,500
24. b0lsc0tt3,500

1. azadisaryev300,540
2. gdemaria266,244
3. SidFishes261,451
4. _agx_256,402
5. mrichmon217,323
6. pinaldave152,619
7. dgrafx125,222
8. Zvonko102,790
9. duncancu...100,935
10. trailblazzy...98,698
11. anandkp97,332
12. Plucka90,959
13. Jester_4875,737
14. mmc98dl172,536
15. Tacobell77764,577
16. usachrisk...63,028
17. SBennett55,878
18. srikanthm...53,766
19. mkishline43,784
20. hart41,025
21. zadoc39,050
22. jyokum38,360
23. shooksm38,199
24. erikTsomik37,378
25. danrosent...37,345