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
