getting a record id

Results 1 to 3 of 3

Thread: getting a record id

  1. #1
    Jack Johnson Guest

    Default getting a record id

    I am inserting a record into a database and need to obtain the id of the record. I have used ASP Faq 79 but cannot get it to work, here is the code I am using: (I did not put in where I obtain the values of the variables etc.) The database connection is DBConn<BR><BR>&#060;!--#include file="../"--&#062;<BR>Set RS = Server.CreateObject("ADODB.Recordset")<BR> <BR> RS.Open "subscribers", DBConn, openMode, lockMode, adCmdTable<BR> RS.AddNew<BR> RS("first_name") = strFName<BR> RS.Update<BR> Record = RS("subscriber_id")<BR> response.write Record<BR> RS.Close

  2. #2
    Join Date
    Dec 1969

    Default RE: getting a record id

    Are you getting an error or just no ID#?

  3. #3
    Jack Johnson Guest

    Default RE: getting a record id

    just no id number.

Posting Permissions

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