G
Guy Hocking
Hi there,
I have an ASP/SQL 7 application that rips data from SQL Views onto an ASP
page.
I have a money column in a SQL table that contains money income values.
When data is input to this field it needs to be displayed as money (to 2
decimal places - 10.00 or 7.60)
However, this only seems to be occurring when the user puts in the extra 0,
and if 7.6 is entered, it is still displayed as 7.6
I need all data to be displayed as money values (and it is selected as money
in SQL), so is there any way (either in the table design, View design, or
display on the ASP page) to get the data to 2 decimal places, no matter
what?
Thanks for you help, in advance
--
G
www.bradflack.com
Please remove ANTI and SPAM from my
email address before sending me an email.
I have an ASP/SQL 7 application that rips data from SQL Views onto an ASP
page.
I have a money column in a SQL table that contains money income values.
When data is input to this field it needs to be displayed as money (to 2
decimal places - 10.00 or 7.60)
However, this only seems to be occurring when the user puts in the extra 0,
and if 7.6 is entered, it is still displayed as 7.6
I need all data to be displayed as money values (and it is selected as money
in SQL), so is there any way (either in the table design, View design, or
display on the ASP page) to get the data to 2 decimal places, no matter
what?
Thanks for you help, in advance
--
G
www.bradflack.com
Please remove ANTI and SPAM from my
email address before sending me an email.