Looking over the templates brought me to the same conclusion as that Deb came to (of
course it was easier for me since I looked at that part first ;)
The app works fine when adding/updating records that have NO values for Cost, Price
and Weight, however when CF checks the RANGE on these fields when they contain values,
as Deb pointed out, is where the problems begin. From there you can't which pages
REALLY work and which don't.
I also strongly suggest you remove all of the cflocks in your application, as all the
ones I found were unnecessary (for instance, around your cfapplication tag in
application.cfm). The exclusive locks around the cfqueries serve no purpose and just
eat up page processing time. I see you do have <cftransaction> tags in the right
places, however.
-Andy
> -----Original Message-----
> From: Deb Dickerson [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, May 12, 2001 10:16 AM
> To: CF-Talk
> Subject: RE: REWARD OFFERED
>
>
> It's probably your partdetails.cfm template. It's using _range validation,
> which has a known bug that causes the exact error you're getting. Details
> are here: http://www.allaire.com/Handlers/index.cfm?ID=20622&Method=Full
>
> Deb
>
> > -----Original Message-----
> > From: Karl Simanonok [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, May 12, 2001 8:50 AM
> > To: CF-Talk
> > Subject: REWARD OFFERED
> >
> >
> > I'm stuck on a thorny problem, and I am offering fifty dollars to
> > the first
> > person who can diagnose and fix it. The ColdFusion code and an Access
> > database can be downloaded from
> > http://autoparts.strategicbrains.com/autoparts.zip .
> >
> > The application is an admin interface for an autoparts database. The
> > problem is intermittent; once in a while the code seems to run okay
> > (although very slowly) but most often it causes arcane ColdFusion errors
> > that don't contain very useful debug information (see below).
> > The problem
> > is not due to a bad install of ColdFusion because I have tried it
> > on three
> > different machines and the symptoms are the same on all. It does
> > not seem
> > to be related to Access or its ODBC driver because the problem remains
> > unchanged if I import the database into SQL Server
> > (ProductDetail.PD_ID may
> > need to manually be made an Identity field in SQL Server if you
> try that).
> >
> > CF errors USUALLY occur when an existing record is updated but can then
> > more easily happen on any of the other templates once errors begin. The
> > most-offending template seems to be partupdate2.cfm, which is
> called from
> > partedit.cfm. ColdFusion returns errors like these:
> >
> > -------------------------
> > Error Occurred While Processing Request
> > Error Diagnostic Information
> > unknown exception condition
> > CFMLInterpreterImp::writeEmergencyMessage
> > Date/Time: 05/06/01 16:19:10
> > Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98; BCD2000)
> > Remote Address: 64.135.30.238
> > -------------------------
> >
> > Or, more commonly:
> >
> > -------------------------
> > Error Occurred While Processing Request
> > Error Diagnostic Information
> >
> > Just in time compilation error unknown parser error
> >
> > The last successfully parsed CFML construct was dynamic text (a CFML
> > expression) occupying document position (17:22) to (17:37).
> > -------------------------
> >
> > I figure there has to be some genius out there who likes an intellectual
> > challenge that will be able to solve this problem. Please note that the
> > application is not complete so the code is still a little makeshift, and
> > there is a fair amount of commented-out debug code. Fifty
> bucks is yours
> > if you diagnose and fix the underlying problem causing these
> > errors, it is
> > not necessary to make the whole application work as it should
> ultimately.
> >
> > Suggestion: start with index.cfm and click on the first Search button to
> > get a list of all the parts in the database on
> > partsearchoutput.cfm. Then
> > click on any of the Edit graphical icons to load partedit.cfm. When you
> > click on either of the Save buttons, you should experience the
> problems I
> > have, maybe not the first time but after just a couple of iterations.
> >
> > To win, just send me working code or even an explanation of your fix if
> > that will suffice. May the best coder win an easy fifty bucks!
> >
> > Regards,
> >
> > Karl Simanonok
> >
> >
> >
> > Archives: http://www.mail-archive.com/[email protected]/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
