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
