Im not too familiar with access so i'm not sure if they support
triggers. But if it did I think that is the best way to go.
If not you should use a <cflock> around a <cftransaction> and doa
select @@ Identity on the table name
On Tue, 2 May 2000 12:54:31 EDT, [EMAIL PROTECTED] wrote:
>I am using Microsoft Access Autonumber to create Key fields for me.
>
>1. Is this a wise thing to do?
>2. If ok , anyone have a nice way of getting the key back. I am currently
>saving a temporary key in one the fields, then finding and changing. This
>seams like a lot of work to create an Insert.
>3. If not, and this might explain all of the discussion about key creation,
>what was the consensous on the best way to generate a unique key?
>
>Thanks,
>Andy
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
