<cftransaction>
insert statement here
<cfquery name="max" datasource="blah">
select max(id) as maxid from table
</cfquery>
</cftransaction>
That way you'll have them both at the same time, and wont have to worry
about anyone inserting anything else at the same time.
Cheers.
----- Original Message -----
From: "Oliver Tomkins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 28, 2003 2:05 PM
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]
