<cfif isdefined("form.edit")> <!--- loop through uid field and evaluate incoming form values ---> <cfloop index="editloop" list="#form.id#"> <cfset variables.Field1 = evaluate("form.Field1" & editloop)> <cfset variables.Field2 = evaluate("form.Field2" & editloop)> <cfset variables.Field3 = evaluate("form.Field3" & editloop)> <cfset variables.Field4 = evaluate("form.Field4" & editloop)> <!--- update all records in loop ---> <cfquery name="rs_edit" datasource="#request.dsn#"> update Tbl_Test SET Field1 = '#variables.Field1#', Field2 = '#variables.Field2#', Field3 = '#variables.Field3#', Field4 = '#variables.Field4#' where id = #editloop# </cfquery> </cfloop> <!--- now delete all checked boxes ---> <cfif isdefined("form.delete")> <cfquery name="rs_delete" datasource="#request.dsn#"> delete from Tbl_Test where id IN (#form.delete#) </cfquery> </cfif> <cflocation url="#cgi.SCRIPT_NAME#" addtoken="no"> </cfif> <cfquery name="rs_nominal" datasource="#request.dsn#"> select * from Tbl_Test </cfquery> <html> <head> <title>Multiple Edit and Delete</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <table width="600"> <form name="frm_edit" method="post" action=""> <tr> <td> </td> <td> </td> <td> </td> <td align="right"> </td> <td align="center">Delete</td> </tr> <cfoutput query="rs_nominal"> <tr> <td><input name="Field1#id#" type="text" value="#value1#" size="4"></td> <td><input name="Field2#id#" type="text" value="#value2#"></td> <td><input name="Field3#id#" type="text" value="#value3#"> <input name="id" type="hidden" value="#id#"></td> <td align="right">£ <input name="Field3#id#" type="text" value="#value4#" size="5"></td> <td align="center"> <input name="delete" type="checkbox" id="delete" value="#id#"></td> </tr> </cfoutput> <tr> <td> </td> <td> </td> <td> </td> <td colspan="2" align="right"> <input name="edit" type="submit" id="edit" value="Submit Changes"></td> </tr> </form> </table> </body> </html>