@@identity in SQL Server OR MAXID in Access -----Original Message----- From: Oliver Tomkins [mailto:[EMAIL PROTECTED] Sent: 28 May 2003 13:53 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] a quickie...
What database server are you using? -----Original Message----- From: Ian Westbrook [mailto:[EMAIL PROTECTED] Sent: 28 May 2003 13:46 To: cfug dev list Subject: [ cf-dev ] a quickie... 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]
