Insert into two tables from a single submit

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default Insert into two tables from a single submit

    Folks:

    Is there a good refresher out there on this kind of shenanigan? (ASP,
    please)

    --
    Murray --- ICQ 71997575
    Team Macromedia Volunteer for Dreamweaver
    (If you *MUST* email me, don't LAUGH when you do so!)
    ==================
    [url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
    [url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
    [url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
    [url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
    ==================


    Murray *TMM* Guest

  2. Similar Questions and Discussions

    1. SQL insert/update problem if coldfusion field value has single quote
      On the coldfusion form, if the user enter the data with single quote in a field (e.g. Joe's Party), and performs SQL insert or update statements,...
    2. Using INSERT with Multiple Tables
      After seeing different tutorials I have reached the conclution to hand code the insert page on my site since it has to update mutliple tables...
    3. Can one <form> submit data to multiple tables?
      Am I able to use a single form to write data to multiple tables in my database using php/mySQL?
    4. Update database without submit button (single page code) ASP
      Please help. Trying to update a record using ASP but within a single page i.e. no submit button. Code below. Thanks in advance - ASP Novice! ...
    5. Parsing to insert single quotes
      I have a .csv file with 1750 records to reformat from time to time which look like: Zenia,7.25,Trinity So far, I'm now getting: ...
  3. #2

    Default Re: Insert into two tables from a single submit

    Murray, you might want to look at my article on the issue

    [url]http://www.charon.co.uk/content.aspx?CategoryID=27&ArticleID=47[/url]

    --
    Jules
    [url]http://www.charon.co.uk/charoncart[/url]
    Charon Cart 3
    Shopping Cart Extension for Dreamweaver MX/MX 2004


    Julian Roberts Guest

  4. #3

    Default Re: Insert into two tables from a single submit

    Wonderful! That's what I was looking for, Jules.

    What if the data is coming from a single form on the page, and one field
    will be inserted into two different tables?

    --
    Murray --- ICQ 71997575
    Team Macromedia Volunteer for Dreamweaver
    (If you *MUST* email me, don't LAUGH when you do so!)
    ==================
    [url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
    [url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
    [url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
    [url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
    ==================

    "Julian Roberts" <newsg@charon.co.uk> wrote in message
    news:d6b9bc$dah$1@forums.macromedia.com...
    > Murray, you might want to look at my article on the issue
    >
    > [url]http://www.charon.co.uk/content.aspx?CategoryID=27&ArticleID=47[/url]
    >
    > --
    > Jules
    > [url]http://www.charon.co.uk/charoncart[/url]
    > Charon Cart 3
    > Shopping Cart Extension for Dreamweaver MX/MX 2004
    >
    >

    Murray *TMM* Guest

  5. #4

    Default Re: Insert into two tables from a single submit

    Hey Jules - your example is so wonderfully simple - I just want to make sure
    I get it.

    By using the AddNew feature, each recordset is written as a new record back
    into the table from which it was taken?

    --
    Murray --- ICQ 71997575
    Team Macromedia Volunteer for Dreamweaver
    (If you *MUST* email me, don't LAUGH when you do so!)
    ==================
    [url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
    [url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
    [url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
    [url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
    ==================

    "Murray *TMM*" <forums@HAHAgreat-web-sights.com> wrote in message
    news:d6be9e$j7u$1@forums.macromedia.com...
    > Wonderful! That's what I was looking for, Jules.
    >
    > What if the data is coming from a single form on the page, and one field
    > will be inserted into two different tables?
    >
    > --
    > Murray --- ICQ 71997575
    > Team Macromedia Volunteer for Dreamweaver
    > (If you *MUST* email me, don't LAUGH when you do so!)
    > ==================
    > [url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
    > [url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
    > [url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
    > [url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
    > ==================
    >
    > "Julian Roberts" <newsg@charon.co.uk> wrote in message
    > news:d6b9bc$dah$1@forums.macromedia.com...
    >> Murray, you might want to look at my article on the issue
    >>
    >> [url]http://www.charon.co.uk/content.aspx?CategoryID=27&ArticleID=47[/url]
    >>
    >> --
    >> Jules
    >> [url]http://www.charon.co.uk/charoncart[/url]
    >> Charon Cart 3
    >> Shopping Cart Extension for Dreamweaver MX/MX 2004
    >>
    >>
    >
    >

    Murray *TMM* Guest

  6. #5

    Default Re: Insert into two tables from a single submit

    Yup, that's just about the gist of it. I've another article on using AddNew

    [url]http://www.charon.co.uk/content.aspx?CategoryID=30&ArticleID=31[/url]

    --
    Jules
    [url]http://www.charon.co.uk/charoncart[/url]
    Charon Cart 3
    Shopping Cart Extension for Dreamweaver MX/MX 2004


    Julian Roberts Guest

  7. #6

    Default Re: Insert into two tables from a single submit

    Thanks, Jules!

    --
    Murray --- ICQ 71997575
    Team Macromedia Volunteer for Dreamweaver
    (If you *MUST* email me, don't LAUGH when you do so!)
    ==================
    [url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
    [url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
    [url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
    [url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
    ==================

    "Julian Roberts" <newsg@charon.co.uk> wrote in message
    news:d6dajj$hqu$1@forums.macromedia.com...
    > Yup, that's just about the gist of it. I've another article on using
    > AddNew
    >
    > [url]http://www.charon.co.uk/content.aspx?CategoryID=30&ArticleID=31[/url]
    >
    > --
    > Jules
    > [url]http://www.charon.co.uk/charoncart[/url]
    > Charon Cart 3
    > Shopping Cart Extension for Dreamweaver MX/MX 2004
    >
    >

    Murray *TMM* 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