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.
