This topic is locked

Floating point number error in SQL Server

3/2/2006 10:12:27 PM
ASPRunnerPro General questions
B
berkeleyjw author

I have a table with a floating point field. I am using SQL Server 2000 as the backend.
Every time I try to add information to this table, I get the following error:
Technical Information (for support personnel)
Error Type:

Microsoft VBScript runtime (0x800A000D)

Type mismatch: 'CDbl'

/ASPRunnerPro/SRM_ACAD_PROG_TBL_add.asp, line 264
Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
Page:

POST 1122 bytes to /ASPRunnerPro/SRM_ACAD_PROG_TBL_add.asp
POST Data:

error '80020009'

Exception occurred.
/iisHelp/common/500-100.asp, line 223
If I remove the floating point number from the table, and rebuild the pages, I no longer receive the error.
I am using ASPRunnerPro 4.0 build 84.
If I run a manual update statement directly against the server backend with the same data I am trying to submit via the _ADD page, I have no problems.
Please advise.

Admin 3/2/2006

Jim,
please download the latest update (build 86) and rebuild your project. Make sure you use default template.
This error is related to comma vs. decimal point issue which happened on some systems. It was fixed in final version.