Retrieving last record when using CreateUUID

[calista]

Does anyone have a good way to retrieve info from a record you just inserted into the DB when you are using CreateUUID to generate the primary key? The primary key is what I want to pass to the next page.

I came up with a rather cumbersome way for another application which involves querying the database table, sorting the records by time created, and selecting the most recent. In this application, I don't neccesarily care about the creation date, but I can include one if needed.

I keep thinking there has GOT to be a better way to do this! Calista :-X
Jedi Knight,
Champion of the Force

 

[CFHub]

If you where to first set a variable=CreateUUID() then "variable" would simply be available to you....

If there is also an "autonumber" field in your database you could use @@identity as well (MS SQL, Access)

http://www.cfhub.com/sql/accesstips/autonumber.cfm

http://cfhub.com/advanced/cftransaction/

 

[calista]

Duh! :~/ It would have to be that simple. And here I was making it a lot harder than it had to be. Thanks! Calista :-X
Jedi Knight,
Champion of the Force