Hi everyone, We are having a problem with a custom order entry system application we have written in ColdFusion using MS SQL 7 database. The problem appears to be that intermittently invalid orders are getting into the system. Frequency is approximately 2 invalid orders every day out of about 120 orders. In addition, we've noticed that 100% of the time for each invalid order there's a hole in the Orders table of the database where there's at least one record immediately after the problem Order table record which does not exist. For example, if Order record # 3500 is found to be invalid, record # 3501 does not exist in the table, but there is record # 3502, 3503, etc. We are using a Begin Transaction, Commit Transaction statement surrounding the multiple SQL INSERTS to insert records into the SQL database.
Anyone have any ideas on what might be wrong? Thanks, Ben Ben Densmore Web Developer TouchStone Software Corp./eSupport.com, Inc. 1538 Turnpike St. North Andover, Ma 01845 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
