If you are on CF9, use result="foo" (or whatever) in the cfquery tag. Then you can use
foo.generatedkey no matter what the db type. On Tue, Sep 6, 2011 at 10:02 PM, Jerry Milo Johnson <[email protected]> wrote: > > What database server are you connecting to? MySQL? MS SQL Server? And > what version of the database server? > > (The answer may change based on this information) > > Jerry Milo Johnson > > On Tue, Sep 6, 2011 at 10:55 PM, Mo Lay <[email protected]> wrote: >> >> Hi Guys, >> >> i am inserting some records and want to get the last record ID inserted. in >> this case i will be able to use this ID in other pages? >> >> thanks >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5533 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
