How Do I update Multiple Records with One Submit??

[Scooby Doobie Doo]

Does anyone have a SOLID example of how this works? I've been struggling with
this concept all day and am not understanding why it won't work. I want to
list output, then alter the output, then update them all at once by clicking
one button, but have not been able to do so. Can Anyone point me to a solid
example? I even bought a book today and it doesn't have this topic covered in
it.

[Scooby Doobie Doo]

Here's what I have so far, and this is NOT working. I'm using an access
database. <CFQUERY NAME='GETSITES' DATASOURCE='KeyWebData'> select * from
tbl_sites </CFQUERY> <cfset #currentpage# = 'test.cfm'> <cfset #datasrc# =
'datafeed'> <cfif IsDefined('form.SiteList')> <cfoutput query='GETSITES'>
<cfset TheSitename = evaluate('SITENAME_#GETSITES.SITEID#')> <cfset SITEID =
evaluate('SITEID_#GETSITES.SITEID#')> <cfquery datasource='#datasrc#'>
UPDATE TBL_SITES SET SITENAME = '#Form.SiteList#' WHERE SITEID =
#SITEID# </cfquery> </cfoutput> <cflocation
url='#CurrentPage#?update=no'> </cfif> <form
action='<cfoutput>#CurrentPage#</cfoutput>' enctype='multipart/form-data'
method='post'> <table border='0' cellpadding='2' cellspacing='2'>
<cfoutput query='GETSITES' MAXROWS='15'> <tr><td><input
name='SITENAME_#GETSITES.SITEID#' type='text' VALUE='#ucase(SITENAME)#'
size='50'></td></tr> <input name='SITEID_#GETSITES.SITEID#' type='hidden'
value='#GETSITES.SITEID#'> </cfoutput> </table> <input type='hidden'
name='update' value='yes'> <input type='submit' name='Submit' value='Submit'>
</form>

[Latino]

There's an example at [url]http://tecito.com[/url]

[fhilliard]

Here's an example:
[url]http://frankhilliard.com/multiplerecords.cfm[/url]

[Scooby Doobie Doo]

Thank you Latino and Fhilliard! Both excellent examples and a great help to me. I appreciate your assistance.