Hello,
I am working on the medical form. There are some values that needs to be stored in decimal (like blood chlosterol).
Now I am facing a problem of storing the value, and I want user to follow the rule.
In the paper form the section is like this.
fS-Col: , _ (to explain to you, it is "number number, number") like 56,3
There are two choices I have:
First: In SQL table, I should make two tinyint fields. Then I should display the input boxes on the webpage like [ ],[]. Not a good idea because we will be downloading that data.
Seciond choice: is to make one tinyint field in the SQL. Then on the table I should "parse" the user input. For example, if he enters 53.4 then I should process decimal point as comma (European decimal system). How can I do that?
And how can display ##,# and when user selects that textbox, the ##,# should disappear?
Please give me a hint, and an example would be great 