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.
jon
----- Original Message -----
From: "Bud" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, February 17, 2001 4:26 AM
Subject: cftransaction and Access autonumber
> Hi. I've got a client that every now and again finds her sequence of
> order IDs skips a number. I do the thing where I put cftransaction
> around the order being entered, get the max(order_id) as lastorder,
> then use that ID for the line items. If there is an error or a
> timeout between the ID being incremented in the orders database and
> the items being entered into LineItems, and the transaction rolls
> back, then the user has to refresh or go back and enter again, will
> that cause Access to go the the next number in the sequence? I don't
> know how else to explain it. It doesn't happen often. Every couple
> hundred orders or so.
>
> TIA,
> --
>
> 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
