Thanks a lot! The problem is solved.
Yuri
---------- Original Message ----------------------------------
from: Ross <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Thu, 23 Aug 2001 06:03:38 -0700 (PDT)
>You didn't say what db server you are running but if you are running MS
>SQL Server and don't mind sacrificing portability then this type of
>thing works very well:
>
><cfquery name="MyQuery">
>SET NOCOUNT ON
>INSERT INTO MyTable
>(Field1, Field2)
>VALUES(#myField1#, #myField2#)>
>SET NOCOUNT OFF
>SELECT @@IDENTITY AS ID
></cfquery>
>
>The new ID is then available as MyQuery.ID
>
>
>--- Yuri Vorontsov <[EMAIL PROTECTED]> wrote:
>> One more off-topic question. Does anyone know how one can retrieve
>> a unique id of a row in a SQL query? I need smth like:
>>
>> select ???? as this_row_uid
>>
>> Any ideas?
>> Thanks a lot!
>>
>> Yuri
>>
>>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
