upgrade to SQL Server :)....sorry that's not very helpfull but as far as I know you can't easilly. You have no access to Inserted or @@IDENTITY as you do in SQL Server
------------------------------------------------------------------ Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net ------------------------------------------------------------------ United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 ------------------------------------------------------------------ New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 ------------------------------------------------------------------ The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -----Original Message----- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: 27 September 2001 12:51 To: CF-Talk Subject: Last Record's Autonumber value. Hey all, How can I tell what the Autonumber value of a record I just inserted is using Access? So I enter a User, and then I want to display that user's ID back to them. UserID is an Autonumber field, so I don't know it until after I insert. I can't search for First name or last name, because those could be duplicated. Do I do a Top 1 in a SQl query and wrap the entire thing in a CFTransaction? -Gel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
