Signup · Login
Stardeveloper.com  
Home · Tutorials · Forums · Web Hosting Plans · Faisal Khan's Blog · Contact
Forums : ASP : ADO/ODBC : Adding records to the database with ASP Signup · Login
Author Thread
Adding records to the database with ASP
Posted in tutorial: Adding records to the database with ASP
·  mballard
User
Joined: 13 Apr 2006
Total Posts: 1
Adding records to the database with ASP
Posted: 13 Apr 2006
Is there a way to return the Identity ID after an insert using the Connection object. I am using the following code:

Conn.Open strConnection
Set cmd.ActiveConnection = Conn
cmd.CommandText = strSQL
Set rs = cmd.execute

The insert does not return the inserted record.

rs.fields.Count always =0

Is there a way to get the return of the inserted record?

Thanks for you help

Users Who Have Visited This Thread In Last 24 Hours
3 Visitors

Login
UserName Or Email Address:       Password:       Auto-Login:    
· Create New User Account
· Send Forgotten Password by Email
 
© 1999 - 2009 Stardeveloper.com, All Rights Reserved.