Updating Items in a looping Recordset?

[iam bennu]

I am trying to update a checkbox var in my database for multiple items that
are displayed with a looping Query. I put the whole query in a form and am
trying to check the boxes and the press the submit button and see the new
updated values.

How?!

Any help is appreciated.

iam

The Update Query that Dreamweaver created is below. How to I modify it to
work or do I have to trash this and try a differnt approach.



<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfif IsDefined("FORM.MM_UpdateRecord") AND FORM.MM_UpdateRecord EQ "form1">
<cfquery datasource="CHIShoppingList">
UPDATE HouseHoldItems
SET Item=
<cfif IsDefined("FORM.Item") AND #FORM.Item# NEQ "">
'#FORM.Item#'
<cfelse>
NULL
</cfif>
, BuyNow=
<cfif IsDefined("FORM.checkbox")>
1
<cfelse>
0
</cfif>
WHERE ItemNo=#FORM.Item#</cfquery>