Problem in my database results regions

[samuel]

I have a form in page1.asp where you enter one value in
field1.

The form also has a form handler that calculates a total8
by multiplying field2 by 4.6331. The total is most of the
times a decimal value itself.

<input type="submit" value="Submit" name="B1"
onclick="this.form.total8.value = parseInt
(this.form.field1.value) * 4.6331;return true;">

I post this information in page2.asp by doing form
properties, and send to other>> page2.asp.

In page2.asp, I upload the form values from page1.asp by
inserting a custom query on the database results wizard:

insert into results (field2, total8) values
('::field2::', '::total8::')

Then I display the results that have been posted on the
database by inserting anothe database results region.

The numbers show and are correct but they get rounded up
and show as an integer with no decimal. I would like the
results to include two decimal.

I have tried to change the properties on the database
itself by defining the value as a number and assign two
decimal but no luck.

Can anyone help?

Regards,

Samuel

 

[Kathleen Anderson [MVP - FP]]

Add the FORMAT function to the SQL in the page that displays the results; similar to this: http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency (without the $)

--

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

What You Should Know About the Blaster Worm and Its Variants
http://www.microsoft.com/security/incident/blast.asp