I think you will find @@identity works in access nowadays > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 19 March 2004 11:13 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] WooHoo It works ... > > > MAX(ID) is Access aint it <spit/> > > > > -----Original Message----- > From: Ian Westbrook (BT account) [mailto:[EMAIL PROTECTED] > Sent: 19 March 2004 11:06 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] WooHoo It works ... > > couldn't you also do... > > <cftransaction> > > <cfquery name="add_to_ReportNames" datasource="WebUserDSN"> > INSERT INTO Report_Names (report_name, path_name, > Doc_Type_ID) VALUES ('#trim(form.entered_report_name)#', > '#trim(form.entered_path_name)#', > '#trim(form.selected_doc_type)#') > </cfquery> > > <cfquery datasource="#dsn#" name="getlast"> SELECT MAX(id) AS > 'last_record_ID' </cfquery> > > ... > > </cftransaction> > > ?? > > Ian W > > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, March 19, 2004 11:00 AM > Subject: [ cf-dev ] WooHoo It works ... > > > > > > I came up with this ... > > > > <cftransaction> > > <!--- First addrecord to reportNames and get the @@identity > > which will give last record_ID created ---> > > <cfquery name="add_to_ReportNames" datasource="WebUserDSN"> > > INSERT INTO Report_Names > > (report_name, path_name, Doc_Type_ID) > > VALUES > > ('#trim(form.entered_report_name)#', > > '#trim(form.entered_path_name)#', > > '#trim(form.selected_doc_type)#') > > SELECT @@IDENTITY AS 'last_record_ID' > > </cfquery> > > <cfquery name="add_to_Details" datasource="WebUserDSN"> > > INSERT INTO Details > > (Report_ID, Phase_ID, Group_ID, Menu_Group) > > VALUES > > ('#add_to_ReportNames.last_record_ID#', > > '#trim(form.selected_phase_type)#', > > '#trim(form.selected_group_type)#', > > '#trim(form.selected_menu)#') > > </cfquery> > > </cftransaction> > > > > > > Thanks all for the help ... > > > > > > Regards - Paul > > > > > > > > > > > ************************************************************** > ************** > ********************* > > The information contained within this e-mail (and any > attachment) sent > > by > Birmingham City Council is confidential and may be legally > privileged. It is intended only for the named recipient or > entity to whom it is addressed. If you are not the intended > recipient please accept our apologies and notify the sender > immediately, or telephone +(44) 121 303 6666. Unauthorised > access, use, disclosure, storage or copying is not permitted > and may be unlawful. Any e-mail including its content may be > monitored and used by Birmingham City Council for reasons of > security and for monitoring internal compliance with the > office policy on staff use. E-mail blocking software may also > be used. Any views or opinions presented are solely those of > the originator and do not necessarily represent those of > Birmingham City Council. We cannot guarantee that this > message or any attachment is virus free or has not been > intercepted and amended. > > > > > ************************************************************** > ************** > ********************* > > > > > > -- > > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > CFDeveloper Sponsors and contributors:- *Hosting and > support provided > > by CFMXhosting.co.uk* :: *ActivePDF provided > by activepdf.com* > > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > > > > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > This e-mail is from Reed Exhibitions (Oriel House, 26 The > Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a > division of Reed Business, Registered in England, Number > 678540. It contains information which is confidential and > may also be privileged. It is for the exclusive use of the > intended recipient(s). If you are not the intended > recipient(s) please note that any form of distribution, > copying or use of this communication or the information in it > is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the > sender or call our switchboard on +44 (0) 20 89107910. The > opinions expressed within this communication are not > necessarily those expressed by Reed Exhibitions. Visit our > website at http://www.reedexpo.com > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] >
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
