Hello and welcome to our community! Is this your first visit?
Register
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
    Posts
    41
    Thanks
    4
    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
    New Coder
    Join Date
    Feb 2008
    Posts
    55
    Thanks
    1
    Thanked 0 Times in 0 Posts
    is that meant you used coldfusion script?

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

    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
    •