How to Get Identity of New Record
Published on 2/17/2006 by Site Editor
|
Vote this tutorial:
|
More articles in ASP
Sometimes you need the learn new record number while your are adding a new record. Following example adds a new records to a table and gets the the autonumber or identity of that records.
<%
Set Con = CreateObject("ADODB.Connection")
Con.Open strCon
Con.execute ("INSERT INTO users (email, pword) VALUES ('"& email &"', '"& pword &"')")
set rs = Con.execute"SELECT @@IDENTITY from users")
response.write "Last Record ID is : " & rs(0)
%>
no comments submitted
Latest Posts
- Create and retrieve cookies
- Easy Error Handling in C#
- Filtering results from database
- Filling Data into Select List
- Working with Array Remove An Item
- Custom Paging in ASP Fast And Easy
- Display Top N records from MS Access
- Using GetRows To Get All Records From Table
- VBScript Functions The Len Function
- Free User Registration Form
- Copying Folders using File System Object
- ArrayList object usage with example
- Using SUM Function in An SQL Statement
- Compacting an Access database from ASP code
- Database Driven Login Script
- Methods of Session Object
- Simple XMLRSS Parser Part-II
- Selecting random record from database
- Image downloading from remote servers in ASP
- How to Encrypt String Using MD5
