var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: problems with decimal (myODBC & ADO)
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.