Key of record just inserted

Anyone know how to access the key of the record just inserted in a cfquery insert statement?
Who is Participating?
cfhubConnect With a Mentor Commented:
There are a couple of ways:

The "best" would also incorporate a CFTRANSACTION tag (just in case something goes wrong)

More simply, something like this should work (Access/MS SQL only)
lauriepmissoulaAuthor Commented:
Thanks for the quick helpful response!
All Courses

From novice to tech pro — start learning today.