Decimals in field of 'Database results' (losing zero's)

[Nadia]

Hi,
I have a database art.dbf (Microsoft Visual Fox Pro
table). In one field I store the price of my article
as 'numeric' with 2 decimals.
I imported it in Frontpage, but when I want to display
this field, it doesn't put the zero's at the end.
For instance :
price = 24,00 in my table gives price = 24 in my webpage
or 56,30 in my table gives 56,3 in my webpage
Can you help me ?

 

[Kathleen Anderson \(MVP - FrontPage\)]

In your SQL, you could do this:

Format(myAmount,'##,##0.00') as myNewAmount

myNewAmount will show up on your page.

--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/