View Single Post
  #1 (permalink)  
Old April 5th, 2005, 04:09 PM
omninewt omninewt is offline
Registered User
 
Join Date: Apr 2005
Location: Toronto, ON, Canada.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default ASP Add New Record and Get ID

Question regarding adding new records to a database table with ASP.

I'm trying to add a new record to a table, pull the ID, and add new records to linked sub tables based on this ID. I had a little trouble getting the ID after adding a record, because when I requiry, I loose my position in the table.

Therefore I've done a real embarrassing work-around. Basically I date/time stamp the record then pull based on the time stamp (with a little verification for single record results).

I'm sure there are better ways to do this and I hope someone might be able to enlighten me.

Thanks,
Mike



Reply With Quote