After you insert the record into table 1, do a select @@identity to get the last ID inserted. Make sure you wrap your code in a CFLOCK and a CFTRANSACTION to make sure other queries do not insert another record before you get your @@identity back.
Russ > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 18 March 2004 12:11 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Double Action .... > > > > Another problem ... > > I have two tables (I didn't create these so don't blame me ...) > > One table (reports) contains reports with a report ID > (autogenerated) The other (otherinfo) contains other info > with a report ID (not autogenerated and not indexed etc...) > > I need to add a record which will go to the reports table (ok > no problem) but then also add a record to the other info > table with the autogenerated ID number which hasn't been > generated yet if you see what I mean... A sort of double > action page .... > > I didn't even understand that my self so i'll try to explain > better. The user adds a report and a record is generated in > the reports table. This report has an ID no. Whilst the user > was filling in the form other data was collected which will > go into the other data table with the report ID. > > Any ideas on how I can do this ... ? > > > 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]
