Re: Invalid Precision error

Show us the actual error text, or even better provide a stand alone sample script the reproduces the error (I realise this may not be possible given the database involvement).

True laziness is hard work

Comment on Re: Invalid Precision error

Replies are listed 'Best First'.
Re^2: Invalid Precision error by Bheema_Tyco (Novice) on Apr 28, 2010 at 05:17 UTC
DBD::ODBC::st execute failed: Microsoft ODBC SQL Server DriverInvalid precisi on value (SQL-HY104) at ODBC_error.pl line 119. Issuing rollback() due to DESTROY without explicit disconnect() of DBD::ODBC::db handle NaviStor_s7200_IndiaCOE at ODBC_error.pl line 119. This is the error	[reply]
Re^3: Invalid Precision error by GrandFather (Saint) on Apr 28, 2010 at 05:48 UTC
So it is a data base error. You need to examine the SQL and values that you used at the point that you get the error then clean up the data you are feeding to the data base. True laziness is hard work	[reply]
Re^3: Invalid Precision error by mje (Curate) on Apr 28, 2010 at 10:19 UTC
I bet it is a problem with one of your dates. Show us the SQL and any parameters at error time. You can do this with Statement and ParamValues and ParamTypes.	[reply]