> I've a query which inserts several form fields and values to
> a DB - I've set
> the ID of the records in Access to AutoNumber, and immediately after
> inserting the data I want to find out what the ID is.
The other way is simply to use SELECT Max(ID) AS TheNewID FROM TableName
You need to wrap <cftransaction> around the two queries.
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
