AutoNumbers and INSERTS

Hi, I'm inserting a load of data into a Table of an Access Database. The ID field is generated by AutoNumber. As soon as the record has been inserted, I need to output what that ID was. How can I do this? Cheers Will...

Re: AutoNumbers and INSERTS

- Original Message - From: "Homer Simpson" [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Friday, September 29, 2000 1:38 PM Subject: RE: AutoNumbers and INSERTS You could try adding the data with a CFQUERY INSER and then immediately after do a CFQUERY SELEC

Re: AutoNumbers and INSERTS

Hi Will, There are two real possibilities: 1) stick with autonumbering. Wrap your insert and a SELECT Max(ID) inside a single CFTRANSACTION. Vaguely ugly. 2) Create your own Primary Key. 2a) Create your own incremental ID from a separate table. Needs CFTANSACTION. 2b) Create an incremental

RE: AutoNumbers and INSERTS

e- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 5:00 AM To: CF-Talk Subject: AutoNumbers and INSERTS Hi, I'm inserting a load of data into a Table of an Access Database. The ID field is generated by AutoNumber. As soon as the record has been inserted, I