FLOAT problem

[gwp]

Hi!

I´m running ASP and MySQL where I´m using the datatype FLOAT.

When I submit a value, for example myValue=’50.5’ it works fine and when I check the value in the database it is 50.5

But then, when I try to print this on a .asp page - using SELECT myValue AS nVal – RS(“nVal”) I get the value 50 printed.

What is causing the rounded value, is it a WIN/ASP/MySQL setting or am I doing something wrong?

Thanks in advance for any answers /The Swedish Pike

 

[sleipnir214]

To begin with, I would not use

myVal = '50.5'

with a numeric column type. The quotes tell MySQL to expect a string -- drop the quotes when inserting the data around numeric values going into a numeric column type. Even if it does not fix this problem, you can get a performance boost.

Also, I'm confused as to what

SELECT myValue AS nVal – RS(“nVal”)

is supposed to do. The "AS" keyword sets up an alias for a column. You generally use it like this:

SELECT 1 + 2 AS three;

will return:

+-------+
| three |
+-------+
|     2 |
+-------+

This gives a name MySQL can associate with a calculated column that would not normally have one.


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[gwp]

Thanks for your reply!
I´m sorry about the confusion, I did not write the complete code. I use it because i call several tables with identical column names. Like this....
myTable1.myValue AS myVal1 , myTable2.myValue AS myVal2