I am trying to update multiple rows by looping through:
<cfloop query="GetExpOrg">
(diagnostics) <cfoutput>row: #GetExpOrg.currentrow# id:
#GetExpOrg.ExpOrg_ID#</cfoutput><br>
<cfquery datasource="#application.datasource#" name="UpdateExpOrg">
update Project_ExpOrg
set OrgValue=(select org_value from expressionorganism3
where exporg_id = #GetExpOrg.ExpOrg_ID#)
where project_id = #url.ProjectId#
</cfquery>
</cfloop>
my diagnostics give me:
row: 1 id: 2
row: 2 id: 693
so that is ok.
but both rows are updated with the last value (693) instead of being
individually updated?
What's wrong with this?
TNX if you can help.
Rick.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338773
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
