It's in the record you committed. IE: myRecord.getMyRecordId() Doug
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daryl Sent: Friday, April 07, 2006 12:21 PM To: [email protected] Subject: [Reactor For CF] MySQL4: accessing inserted record id I notice on creating a new record that the debugging shows the standard get inserted query has run (below), but how do i access that id? i've tried dumping #qCreate# but it can't find the query. i looked over the relevant methods generated by reactor for that table and am finding nothing. i also ran a quick search in the email list archives. qCreate (Datasource=efn, Time=0ms, Records=1) in /var/www/html/reactor/project/efn/Dao/ConsumersDao.cfc @ 10:22:36.036 SELECT LAST_INSERT_ID() as Id -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
