#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Posts
    3
    Rep Power
    0

    Multiple record insertion


    I have been searching to try and find a way to do a multiple record insertion from one form. I understand that it can be done with loops but is there an extension out that there that I can download either in coldfusion or dreamweaver? Also, was wondering if anyone knew if it is possible to do in dreamweaver?
  2. #2
  3. No Profile Picture
    Moderator

    Join Date
    Jun 2002
    Location
    Raleigh, NC
    Posts
    5,273
    Rep Power
    968
    What you are looking for is the SELECT INTO operator. Check your database documentation for examples on how this is done.

    However, if for some reason your database does not support SELECT INTO, then no, there is no extension to CF or Dreamweaver to let you do this. You'll have to write a loop to handle multiple inserts either in CFML or as a stored procedure.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Posts
    3
    Rep Power
    0
    Okay, that doesn't work because I am using a checkbox as the submit button and would like for a window to pop and verify that it is to be inserted and then insert if that is what needs to be done. But for some reason all of my variables aren't being passed into that form.
  6. #4
  7. No Profile Picture
    Moderator

    Join Date
    Jun 2002
    Location
    Raleigh, NC
    Posts
    5,273
    Rep Power
    968
    You're trying to do too much at the same time. Start by using a standard form and posting it in the standard way to a target page. Get the multiple inserts working. Then slowly add or change the code.

    I guess the bottom line is that multiple inserts can be done with 100% certaintly in CF, either with a loop or with SELECT INTO in the query. So the problem must be in the way you are handling the form or performing your query.
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Posts
    3
    Rep Power
    0
    Okay. Thanks.

IMN logo majestic logo threadwatch logo seochat tools logo