Yes ... and the method depends on the database you are using. What databse
are you using.
Also, this topic has been covered multiple times on this thread and the info
can be found in the searchable archive:
http://www.mail-archive.com/cf-talk@houseoffusion.com/maillist.html
Take a look there.
Cheers,
Bill
In a message dated 4/5/01 10:08:11 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> is there anyway to output the last primary key number in a table after an
> insert statement?
> i need to capture that number on the same action page so i can pass it to
> another table.
> in other words, on my insertApp.cfm i have the query to update my apps
> table.
> but on this same page at the bottom, i have another form...a form to update
> the licensing. when i submit this form, i need that primary key from my
> apps table to pass thru to my licensing table.
> so i need a way to capture that value.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists