Results 1 to 2 of 2

Thread: SQL ...Asp problem

  1. Oct 12th, 2000, 04:14 PM #1
    ptran
    ptran is offline

    Thread Starter
    Member
    Join Date
    Jan 2000
    Posts
    51
    I have the following code, within the same ASP session, I can't seem to get the InvID after I add it into the SQLServer. Is there Anyway I can get the value of InvID without futher coding?

    Thanks

    Set rsContact = CreateObject("ADODB.Recordset")
    Set rsContact.ActiveConnection = objConn
    rsContact.Locktype = 2
    rsContact.AddNew
    rsContact.Update

    InvID = rsContact("InvID")
    Reply With Quote Reply With Quote
  2. Oct 31st, 2000, 10:14 AM #2
    ShIzO
    ShIzO is offline
    Addicted Member ShIzO's Avatar
    Join Date
    Apr 1999
    Location
    Bartlett, IL
    Posts
    189
    what are u trying to do?

    get the next id from the database?
    www.HardFind.com -buy/sell/trade your used hardware.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width