Where does the UpdateID come from? Maybe it should Form.RecID, no?
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
