CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. April 23rd, 2008, 06:09 AM #1
    Nibinaear
    Nibinaear is offline Member
    Join Date
    Dec 2004
    Posts
    438

    ASP Classic - ADO Recordsets - Getting last insert id?

    I'm using ASP Classic for a legacy site we're working on. I'm using the ADO recordsets to get back information from the database.

    Is there any way of finding the last insert id for the recordset, such as a built in keyword or function? Or do I have to get the last insert with a function and then add one to it?
    Reply With Quote Reply With Quote
  2. April 23rd, 2008, 07:58 AM #2
    PeejAvery's Avatar
    PeejAvery
    PeejAvery is offline Elite Member Power Poster
    Join Date
    May 2002
    Posts
    10,943

    Re: ASP Classic - ADO Recordsets - Getting last insert id?

    Unlike MySQL/SQL, ADO does not requery the database by its own accords. This means you will have to do it yourself.
    If the post was helpful...Rate it! Remember to use [code] or [php] tags.
    Reply With Quote Reply With Quote
  3. April 25th, 2008, 09:45 AM #3
    Nibinaear
    Nibinaear is offline Member
    Join Date
    Dec 2004
    Posts
    438

    Re: ASP Classic - ADO Recordsets - Getting last insert id?

    wrong thread.
    Reply With Quote Reply With Quote
  4. April 25th, 2008, 11:29 AM #4
    PeejAvery's Avatar
    PeejAvery
    PeejAvery is offline Elite Member Power Poster
    Join Date
    May 2002
    Posts
    10,943

    Re: ASP Classic - ADO Recordsets - Getting last insert id?

    Wrong thread? What do you mean?
    If the post was helpful...Rate it! Remember to use [code] or [php] tags.
    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

Featured