You can use cflock like that? So basically you can replace <cftransaction > with a cflock? That right?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 28 May 2003 13:52 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] a quickie... <cfquery datasource="#dsn#" name="thistown"> SELECT MAX(id) AS MaxID from towns </cfquery> Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Ian Westbrook" To: "cfug dev list" <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: eam.net> Subject: [ cf-dev ] a quickie... 28/05/2003 13:45 Please respond to dev sorry, another quickie I want to get the id of the record I just added (CF4.5). I'm using this <CFLOCK TIMEOUT="30" TYPE="Exclusive"> <cfquery datasource="#dsn#"> INSERT INTO towns (town) VALUES ('#form.town#') </cfquery> <cfquery datasource="#dsn#" name="thistown"> SELECT id from towns </cfquery> </CFLOCK> do I want ASC/DESC LIMIT 1 in the 'thistown' query, or maxrows="1" on the output? TIA Ian W Ian Westbrook, FutureDream Media Limited, (W): www.futuredream.net (E): [EMAIL PROTECTED] (T): +44 (0) 1303 258 985 (M): 07939 510 812 This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding any comments, opinions, information or conclusions expressed in this message are those of the originator, not of FutureDream Media Ltd, unless otherwise explicitly and independently indicated by an authorised representative of FutureDream Media Ltd. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
