mikanuu
02-27-02, 17:36
| Hi, I have problems with accessing mySQL through ADO & myODBC from ASP page. Everything else seems work fine, but I cannot select data with decimals correctly. First I used double type, but data is always truncated to integer when I access value through recordset (Response.write(rs(FIELD_NAME)) returns e.g 6 even if in the db value is 6.6) Then I read from documentation or some FAQ that DECIMAL type should be used, and I made the field to be of type DECIMAL(3,1). This time when accessing field through recordset I received exception or multiple errors: Microsoft OLE DB Provider for ODBC Drivers error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Can anybody instruct me how can I use decimals on my pages? In every cases INSERT worked fine. With mySQÖ command line I could verify that e.g 6.6 is stored into db correctly. -- Mika |