We are using cfstoredproc tags and they have been working fine for a couple of years. The back end is SQL server 2000. Currently we're doing an upgrade from cf4.5 to cfmx, and having problems with executing database query. The error message is:
The Error is Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Invalid precision value
We don't have precision value. We have int, bit, datetime, varchar... Where might the problem be from?
I tested to move the query statement part from the stored procedure to the front with cfquery, the error is gone. But I really need to know what causes the problem as I don't want rewrite every page with the cfstoredproc tags . Any hint is appreciated!
Thanks!
Jianhua
The Error is Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Invalid precision value
We don't have precision value. We have int, bit, datetime, varchar... Where might the problem be from?
I tested to move the query statement part from the stored procedure to the front with cfquery, the error is gone. But I really need to know what causes the problem as I don't want rewrite every page with the cfstoredproc tags . Any hint is appreciated!
Thanks!
Jianhua