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