-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Is there any built-in function that will give me the ID of the most recent
database insert? For instance, when the user inserts a new record, I want
to immediately retrieve the new record ID for use in a confirmation message
and email.
I suppose I can wrap the insert and then a select MAX(id) for that
particular user in a CFTRANSACTION, but there must be a more elegant way?
c
- --
Chris Lott <[EMAIL PROTECTED]>| IT Manager|p907-474-3494
-----BEGIN PGP SIGNATURE-----
Version: 6.5.8ckt http://irfaiad.virtualave.net/
iQA/AwUBOduMztaLYehRBGz9EQJIUACfWr2TysaV5wHTvAV4nvjn1Zdo0nAAoPck
BcMa40G39FpQLcoSJ4nCIiwS
=YFaI
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
