Hi guys,
I'm inserting a record to a database, but once I have inserted the
record I want to email the user their details including their UserID
which is an autonumber (primary).
To grab the last inserted row should I use the CFLOCK around my query
and my cfmail? Is there such a thing as Last.UserID which will give me
the last insert of UserID?
Cheers,
Stuart
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- RE: cftransaction HELP Please... Andy Ousterhout
- RE: cftransaction HELP Please... Dave Watts
- RE: cftransaction HELP Please... Douglas.Knudsen
- RE: cftransaction HELP Please... Andy Ousterhout
- RE: cftransaction HELP Please... Dave Carabetta
- RE: cftransaction HELP Please... Dave Watts
- RE: cftransaction HELP Please... Andy Ousterhout
- RE: cftransaction HELP Please... Dave Watts
- Re:cftransaction HELP Please... Spectrum Web
- RE: cftransaction HELP Please... Pascal Peters
- Re: CFLOCK:....Sunday (still not left computer al... Stuart Kidd
- Re: CFLOCK:....Sunday (still not left compute... Dave Carabetta
- RE: CFLOCK:....Sunday (still not left com... Simon Horwith
- RE: CFLOCK:....Sunday (still not left... Jochem van Dieten
- RE: CFLOCK:....Sunday (still not... Simon Horwith
- Random Password Stuart Kidd
- Re: Random Password Critter
- RE: Random Password Stuart Kidd
- Re: Random Password Critter
- RE: Random Password Michael T. Tangorre
- RE: CFLOCK:....Sunday (still not left... Stuart Kidd