Get the ID generated from the previous INSERT operation.

In php this is called mysql_inset_id(); i was wondering if asp has somthing like this.

Do you suppose you could spare more than 24 words to explain what it is that you are trying to do?
Database INSERT?
Which database management system then (if so)?
What is the intended use of what it is that you are trying to get?
And so on.

In MSSQL you can use "SELECT @@IDENTITY AS LastID"
Or use "SELECT MAX(ID) AS LastID FROM Table"

That would work, here is another way to skin the same cat:

sql = "SELECT TOP 1 [idFieldName] FROM [tbleName] ORDER BY [idFieldName] DESC;"

BTW: Use trailing semi colons at the end of your SQL. This is not required but very Recommended. This explicitly terminates the statement and helps prevent SQL injections:

TIP: Place your sql language posts in the SQL area of the forum for the best possible solution.

Wind is your friend
Matt