How do I get the ID of the last inserted record?

	Home Register Search Help Login

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Sponsors
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

How do I get the ID of the last inserted record?

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> How do I get the ID of the last inserted record?

Page: [1]

HTML Templates, Flash Intros, Joomla!,
Wordpress, Drupal, Zen Cart, and More. Click here to shop.


Spooky Posts: 26630 Joined: 11/11/1998 From: Middle Earth Status: offline	How do I get the ID of the last inserted record? - 11/20/2002 13:51:37 http://www.aspfaq.com/show.asp?id=2174 http://support.microsoft.com/?kbid=232144 Interestingly enough, the latest oledb Jet providers support the retrieval of the @@Identity Examples : SQL http://www.kamath.com/tutorials/tut007_identity.asp Access http://www.kamath.com/tutorials/tut004_autonum.asp < Message edited by Spooky -- 2/24/2004 18:22:19 > _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s