How do I pass value to a MySQL column of DECIMAL Datatype correctly? Using VBScript

bharatterminal

New Member
I am using MySQL 5.1 and ASP classic. My Connections are ODBC!My table has a column with a DataType of DECIMAL(8,2)And in my code I show this to develop the parameter.\[code\]Dim p1SET p1 = comm.CreateParameter("p_Price", adDecimal, adParamInput,, bdPrice)p1.NumericScale = 8p1.Precision = 2\[/code\]And then I .Execute the procedure call ..per normal means.This is the Error I am getting:Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.This actually WAS working very well, the whole application is working but all the sudden this one piece failed.Anyone have some ideas?One thing that DID change is we switched from 3.51 ODBC driver to the 5.1 ODBC drive... maybe that did it?
 
Back
Top