I've got a cfloop/form structure set up to allow a user to update one or two
specific fields in specific records.
ID of Record = #MyQuery.Record_ID#
Data field to update = BOB
The loop and form sorta like (not real code):
<cfloop>
<form>
<select name="BOB_#MyQuery.Record_ID#">
<hidden name="RecID" value="#myQuery.Record_ID#
<submit>
</form>
</cfloop>
Using the following query code
<cfloop index="UpdateID" list="#Form.RecID#">
<cfquery datasource="MyData">
UPDATE dbo.app_Master
SET BOB = '#evaluate("FORM.BOB_#UpdateID#")#',
WHERE MSTR_ID= '#UpdateID#'
</cfquery>
</cfloop>
I'm having trouble getting only the specific record to update though... it
wants to update them all......
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
