Or you can just use <cftransaction> to get around that can't you? -----Original Message----- From: Oliver Tomkins [mailto:[EMAIL PROTECTED]
Sent: 28 May 2003 14:06 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] a quickie... Be weary though if there is another record being inserted at the same time you might run into trouble. So how about <cfquery datasource="#dsn#" name="thistown"> SELECT MAX(id) AS MaxID from towns WHERE column = 'something I've just inserted' </cfquery> -----Original Message----- From: Ian Westbrook [mailto:[EMAIL PROTECTED] Sent: 28 May 2003 13:55 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] a quickie... boootiful. ta ;-) Ian ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 28, 2003 1:52 PM 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] -- ** 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]
