Thanks Azadi and Barney. Which approach is better in performance? I'm assuming result.generated_key?
Thanks again for help Agha On Sep 29, 2009, at 12:20 PM, Barney Boisvert <[email protected]> wrote: > > select last_insert_id() as id > > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id > > cheers, > barneyb > > On Tue, Sep 29, 2009 at 12:16 PM, Agha Mehdi <[email protected]> > wrote: >> >> All, >> How do I get the ID value back in CF from MySQL after doing an >> insert with >> auto_inc data type in the table? >> >> Thanks for help >> >> Agha >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326751 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
