Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Jun 2008
    Thanked 0 Times in 0 Posts

    update multiple rows of db from user form

    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.

  2. #2
    New Coder
    Join Date
    Feb 2008
    Thanked 0 Times in 0 Posts
    is that meant you used coldfusion script?

    <cfset RESULTS = "

    perhaps that help you


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts