AutoFiled

[akcreative]

Hi

I am adding a record to database field having ID as autonumber. I want to retrieve the auto value on the same template. How can I do that.
Thanks in advance
Mike

[SQLMenace]

If you are using SQL server you can use the @@IDENTITY function or IDENT_CURRENT
Or select Max(Id) from table

[hatethisnamegame]

For Access:
<cftransaction>
<cflock name="addStuff">
<cfquery> insert data </cfquery>
<cfquery>
SELECT MAX (itemID) AS NewitemID
FROM itemsTable
</cfquery>
the auto value can now be accessed by referencing #NewItemID#