Insert & Select

Results 1 to 2 of 2

Thread: Insert & Select

  1. #1
    Join Date
    Dec 1969

    Default Insert & Select

    Hi,<BR><BR>I am inserting a load of fields in to a database via ASP, the database table creates an autonumber once the record has been entered, I need to SELECT that autonumber so that I can pass it to the next page.<BR><BR>How can I do an INSERT and then SELECT the autonumber all in one Query?<BR><BR>e.g-<BR><BR>INSERT INTO Questions (NAME) VALUES (&#039;"&NAME&"&#039;) (SELECT Questions_ID FROM Questions)<BR><BR>Hope it makes sense.<BR><BR>JiMi

  2. #2
    Join Date
    Dec 1969

    Default <eop>


Posting Permissions

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