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.