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.