multiple inserts..

Results 1 to 2 of 2

Thread: multiple inserts..

  1. #1
    Join Date
    Dec 1969

    Default multiple inserts..

    what i want to do is, collect data from a form. post it to an asp page, and insert data into sql server database.... the problem is that half the data on form needs to go into one table, and other half of data needs to be inserted into a different table...<BR><BR>now here is the problem... i do the insert on the first table, (insert a First Name, and generate an auto ID.)... now i want to do the second insert, one of the values i want to enter is the Auto ID that has now been generated on the first table...(I need this ID to get the two tables to relate to each other).<BR><BR>How would I go about doing this??<BR><BR>I have a couple of ideas, but they both are really dodgy... <BR><BR>Thank you very much.<BR>

  2. #2
    Join Date
    Dec 1969

    Default ASPFAQs, category Databases, General

    There is a link to the ASPFAQs at the top right corner of this very page.<BR><BR>Look in the category noted in the subject line of this message for your question.<BR><BR>The ASPFAQs are your friends. Visit your friends often.<BR><BR>

Posting Permissions

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