> I think you are referring to SCOPE_IDENTITY()
No, I did mean @@IDENTITY. Though I am going off of much older threads where it
was used within a cftransaction, and separate cfquery, to retrieve the
Autonumber value from an Access table. Rick's post contained the basic concept,
but with cfinsert instead of cfquery. Again, I have no idea how reliable it is.
> However I seem to recall it did not work last time I tried
> it, but that was
> ages ago. I think it requires latest version of access and
> jet drivers.
You might be right. I have not used it in a while. So it is entirely possible
newer versions support SCOPE_IDENTITY() for Access, not just MS SQL.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337536
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
