On 2/17/01, Jon Hall penned:
>Yup, that is exactly what is happening. Once you insert a new record the
>autonumber index gets incremented. If you delete that record as happens in
>case of an error with cftransaction. The next time a new record is inserted
>it just continues on to the next highest number.

I figured that's what it must be. Thanks for the confirmation.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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

Reply via email to