More than likely would need to see the code associated with the processing page.
"Success is a journey, not a destination!!" Doug Brown ----- Original Message ----- From: "Angel Stewart" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 04, 2002 1:06 PM Subject: Order Mixup.. > I wrote an application that allows people to enter orders and time spent > on a system. > > Today is the first day that the system has gotten any sort of load > testing, although we attempted to do this previously. > > So today we are getting these types of errors, where it seems that Hours > from John, are appearing for employee Jim when John enters them. > > What the hell could be going wrong here? I am using more than one Insert > statement sometimes, as well as grabbing the next number in the sequence > from Oracle in order to do an insert using the code: > > <CFQUERY name="qryGetLastID" datasource="relora" dbtype="Oracle80"> > > SELECT tblmainentry_seq.nextval AS ID > > FROM dual > > </CFQUERY> > > It is wrapped in a CFTRANSACTION though, to attemtp to avoid this. But > the input process is so complicated that there are several CFIF > statements to check for conditions before final Inserts are written and > to build insert statements dynamically. > > Any ideas? > > -Gel > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
