ASP Database Related Get the ID of the record entered Tutorial

Resources Links

Ajax
Articles
Bioinformatics-Tutorials
Database-Tutorials
Free Books
Hibernate-Tutorials
J2EE-Tutorials
J2ME-Tutorials
Java-Tutorials
JavaScript
JDBC-Tutorials
JMS-Tutorials
JSP-Tutorials
Linux-Tutorials
MS Technology
PHP
RMI-Tutorials
Servlets-Tutorials
Struts-Tutorials
Tools For Java Technology
UML-Tutorials
Web Graphics Designing
Web Hosting Tutorial
Web-Services-Tutorials

More Tutorials

JSP Tutorials
Hibernate Tutorials
Struts Tutorials
JSF Tutorials MySQL Tutorials
Spring Tutorials
EAI Tutorials
JAXB Tutorials
Web Services Tutorials
JDO Tutorials
Java Tutorials
Java Certification
Linux Tutorials
Java Servlets
WAP Tutorials
EJB Tutorials
JDBC Tutorials
Bio Informatics
Java Server Faces Java Interview Questions

Tutorial: ASP Database Related Get the ID of the record entered Tutorial

How do I get the Unique ID or Auto ID of the record I just entered? The solution is really quite simple.

Tutorial Details:

Get the ID of the record entered

Assuming your connection is named Conn, that it is an include file in a directory for connections, here is the solution for getting the ID. ( Go get a good understanding of how and why to do this. )

<%Response.Buffer=TRUE%>

<%
DIM x_1 ,x_2, uniqueID
x_1 = "something"
x_2 = "something else"
SQL="INSERT INTO myTable ('" & x_1 & "','" & x_2 & "')
Conn.Execute(SQL)
Set RS = Conn.Execute( "SELECT @@IDENTITY" )
myID = RS("ID")
RS.Close
SET RS = NOTHING
Conn.Close
SET Conn = NOTHING
%>

Read Tutorial at: Click here to view the tutorial

Rate Tutorial: ASP Database Related Get the ID of the record entered Tutorial

View Tutorial: ASP Database Related Get the ID of the record entered Tutorial

Related Tutorials:

Bean Markup Language, Part 1 - JavaWorld August 1999
Bean Markup Language, Part 1 - JavaWorld August 1999

Use a RandomAccessFile to building a low-level database - JavaWorld January 1999
Use a RandomAccessFile to building a low-level database - JavaWorld January 1999

Build an object database - JavaWorld January 2000
Build an object database - JavaWorld January 2000

Using XML and JSP together - JavaWorld March 2000
Using XML and JSP together - JavaWorld March 2000

Use Microsoft's Internet Information Server as a Java servlet engine - JavaWorld June 2000
Use Microsoft's Internet Information Server as a Java servlet engine - JavaWorld June 2000

Take control of the servlet environment, Part 2 - JavaWorld December 2000
Take control of the servlet environment, Part 2 - JavaWorld December 2000

Get disconnected with CachedRowSet , This allows for ResultSet s to be serialized, sent to remote clients, updated
The new J2EE RowSet implementation provides updateable disconnected ResultSets in your JSPs

Build database-powered mobile applications on the Java platform
Build database-powered mobile applications on the Java platform

Navigate data with the Mapper framework
Navigate data with the Mapper framework

Sync up Palm OS with J2ME
Sync up Palm OS with J2ME

J2SE 1.4 breathes new life into the CORBA community, Part 3
J2SE 1.4 breathes new life into the CORBA community, Part 3

Impressive !
Impressive !

Jeff Schmitt's JDBC Page
This tutorial assumes you are using the MySQL database and the GWE JDBC drivers. The host computer is triton.towson.edu.

Using Lucene With OJB
Brian McCallister looks at the Lucene search engine and shows us how to index and retrieve objects from a sample Student application.

Welcome to Java Developers paradise!
Welcome to Java Developers paradise! T his site contains many quality Java, JSP, RMI, MySQL downloads, tutorials, source codes and links to other java resources. We have large number of links to the tutorials on java which will help you learn java

Using MYSQL Database with JSP & Servlets.
Using MYSQL Database with JSP & Servlets. Using MYSQL Database with JSP & Servlets. MY SQL is a powerful RDBMS, which can handle large amount of data. And more interestingly it is free to use, except for some commercial use. you can download it

Connecting to MySQL database and retrieving and displaying data in JSP page
Connecting to MySQL database and retrieving and displaying data in JSP page Connecting to MySQL database and retrieving and displaying data in JSP page This tutorial shows you how to connect to MySQL database and retrieve the data from the

Struts Guide
Struts Guide Struts Guide This tutorial is extensive guide to the Struts Framework. In this tutorial you will learn how to develop robust application using Jakarta Struts Framework. This tutorial assumes that the reader is familiar with the web

Writing more than one cards in a WML deck.
Writing more than one cards in a WML deck. Tutorial First Card Writing more than one cards in a deck. In this lesson we will write application that uses two cards in a deck. First card is displayed only for some time and after that it directly

Web Hosting Guide. Introduction to Domain Name
Web Hosting Guide. Introduction to Domain Name Introduction to Domain Name What is Domain Name? If we have to send a letter to someone, we must know his/her mailing address. In the same way if we want to visit a website, we also need to know its

Site navigation