dao recordset in Coldfusion

[mrsbean]

I want to retrieve the autonumber value of a record that was just added to the database. The value would be added by one administrator (unlikely, nearly impossible for more than one administrator to enter records at the same time). I want to use that autoumber to add some related records in other tables. I read a few things today about a dao recordset. I don't know the syntax for using this in Coldfusion. Can anyone point me toward some resources where I can learn how to do it?

MrsBean

 

[GUJUm0deL]

If you want to grab the ID of a record that was just created, take a look at:

http://mysecretbase.com/get_the_last_id.cfm

____________________________________
Just Imagine.

http://www.imajinarts.com

 

[ecobb]

I would definitely stick with the "Part 2: Platform-Specific Solutions" in that article. Querying a database a second time to retrieve something that the database could have automatically given you in the first query is pointless and just bad coding practice.

Although, the article's author needs to brush up on his SQL Server skills. You're supposed to use Scope_Identity() in this case, not @@identity.



Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[GUJUm0deL]

You can read more about Scope_Identity() vs. @@identity here:

http://blog.sqlauthority.com/2007/0...nt-retrieve-last-inserted-identity-of-record/

ECAR, though I have to admit i've been using the @@identity, and i've seen countless other CF developers use this synatx in the same manner. Might be time I switched over the the correct syntax.

____________________________________
Just Imagine.

http://www.imajinarts.com