Insert Multiple INTO multiple table

Ask a Question related to Macromedia Exchange Dreamweaver Extensions, Design and Development.

  1. #1

    Default Insert Multiple INTO multiple table

    Is there an extension available that can insert into multiple database
    tables and then retrieve the ID of the first insert?
    Andy



    Andy Guest

  2. Similar Questions and Discussions

    1. insert multiple row and table
      I have table1 and table 2, one to many relationship. How do I save 3 rows in table 1 and one row in table 2 at the same time?
    2. Multiple DB Insert
      I have an XML file that has roughly 55,000 records. I need to parse the contents of the file and store it in a database. The problem I'm having is...
    3. Multiple Insert or Looping Insert
      I built an application on an Access DB that allows a dispatcher to log trucks in the field at their location as they call in. There are three...
    4. How to insert multiple records to the same table with a multi-fields form
      Hi all, is it possibile to insert multiple records in the same table? I imagine to build a multi-rows form, with the same number of fields per...
    5. UPDATE MULTIPLE ROWS IN ONE TABLE OBTAINING SUMS FROM ANOTHER TABLE
      UPDATE MULTIPLE ROWS IN ONE TABLE OBTAINING SUMS FROM ANOTHER TABLE I need to update a table with distinct sums from another table. I will...
  3. #2

    Default Re: Insert Multiple INTO multiple table

    Andy wrote:
    > Is there an extension available that can insert into multiple database
    > tables and then retrieve the ID of the first insert?
    Here is some code in ASP that can do the multiple inserts, dont' know
    about the returning of the ID though:
    [url]http://www.charon.co.uk/files.aspx?categoryid=15&filecategoryid=10[/url]

    And heres an article that talks about this a bit:
    [url]http://www.newmanzone.com/recipes/recipe.asp?LinkID=2&Link=index1.htm[/url]

    Here is a commercial extesnion that works with PHP and VBScript:
    [url]http://www.interaktonline.com/Products/Dreamweaver-Extensions/ImpAKT/Features/[/url]


    Beyond that you'll need to specify the server language and the database
    you're working with. Perhaps others will have more suggestions based on
    that info.



    --
    Danilo Celic
    | Extending Knowledge Daily : [url]http://CommunityMX.com/[/url]
    | Team Macromedia for Dreamweaver : [url]http://macromedia.com/go/team/[/url]
    danilocelic *TMM* Guest

  4. #3

    Default Re: Insert Multiple INTO multiple table

    Thank danilocelic

    Much appreciated, i''l try it.
    BTW im using access 2000 and classic asp

    Andy



    "danilocelic *TMM*" <danilo@shimmerphase.com> wrote in message
    news:d3ph9o$lkh$1@forums.macromedia.com...
    > Andy wrote:
    > > Is there an extension available that can insert into multiple database
    > > tables and then retrieve the ID of the first insert?
    >
    > Here is some code in ASP that can do the multiple inserts, dont' know
    > about the returning of the ID though:
    > [url]http://www.charon.co.uk/files.aspx?categoryid=15&filecategoryid=10[/url]
    >
    > And heres an article that talks about this a bit:
    > [url]http://www.newmanzone.com/recipes/recipe.asp?LinkID=2&Link=index1.htm[/url]
    >
    > Here is a commercial extesnion that works with PHP and VBScript:
    >
    [url]http://www.interaktonline.com/Products/Dreamweaver-Extensions/ImpAKT/Features/[/url]
    >
    >
    > Beyond that you'll need to specify the server language and the database
    > you're working with. Perhaps others will have more suggestions based on
    > that info.
    >
    >
    >
    > --
    > Danilo Celic
    > | Extending Knowledge Daily : [url]http://CommunityMX.com/[/url]
    > | Team Macromedia for Dreamweaver : [url]http://macromedia.com/go/team/[/url]

    Andy Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139