update multiple rows of db from user form

[jeffmc21]

Hey guys..

I have a form that basically has seven rows of input. I would like to be able to take the user-inputted data from the form and update the database. In effect, each week I'd want to empty the database's contents (which I do with a DELETE FROM statement at the top of my response page) and then re-populate it with the info submitted from the form.

I thought that using some type of cfloop over a query would work, but I'm very inexperienced with CF, so it's proving not so easy. Is that the best way? and if so, how would I need to organize the cfloop statement? I'm getting conflicting examples from the web.

Thanks for your help in advance.

[destruction]

is that meant you used coldfusion script?

<cfset RESULTS = "
<cfloop>
<cfoutput>
#trim(test.modelnumber)#,
</cfoutput>
</cfloop>">


perhaps that help you