Sorry, my mistake, I see it now in the loop. Have you turned on debugging
and looked at the resulting SQL? Also, maybe you do not need the single
quotes around the UpdateID, if it is an Int...
At 10:08 PM 12/13/2002 -0500, you wrote:
>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
