Currency Formatting in Results

[Guest]

Hi Everyone,

I am sure you are all going to laugh at this question, but I really do need
your help!

I have a databse which users add products for sale with a value i.e. £1.50,
so from the input.asp form they add various items including the price (as
indicated). In the databse (access 2000 btw) the file is storing the correct
value i.e. £1.50, however the price list that I have written using the DRW is
showing any price with a '0' at the and without i.e. £1.5.

This does not occur if the last digit is 1,2,3,4,5,6,7,8 or 9 just zero!

How do I force the formatting of the DRM to show values that end with zero
or more to the point exactly as the value appears in the db?

Tia

Jonathan

 

[Kathleen Anderson [MVP - FrontPage]]

http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

 

[Guest]

Thanks Kathleen, sorry to ask you to hold my hand on this one but - when I
change anypart of SQL created by the DRW it won't save the amends and just
coverts the scripting back to it's own saying I am not allowed to change the
SQL.

am I changing the wrong bit of the code? This is my SQL

<%
fp_sQry="SELECT * FROM menu WHERE (show = 'Yes' AND prodcode =
'silverware')"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="description"
fp_sMenuValue="description"
fp_sColTypes="&UID=3&prodcode=202&description=202&price=6&show=202&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

If I try to chnage this code it should won't change it - I am I looking at
the wrong part of the code?

Tia

Jonathan

 

[Kathleen Anderson [MVP - FrontPage]]

Jonathan:
Run the wizard again, and paste this into the custom query box.

SELECT *, Format(price,'$#,##0.00') as newPrice FROM menu WHERE (show =
'Yes' AND prodcode = 'silverware')"

The field newPrice will show up on your results page.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

 

[Guest]

Duh - I really must start to learn this stuff properly rather than relying on
your guys & the FP wizards.

Thank you Kathleen - I will have another look at your Website again for even
more good tips and tricks.

Once again Thank you!

Jonathan

 

[Kathleen Anderson [MVP - FrontPage]]

I'm glad to help.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

 

[Guest]

Can I be really cheeky and ask you one more question about formatting?

I have another report similar to the products one below, but lists a series
of dates firstly in the db the format is UK dd/mm/yyyy but the results page
shows the date american style mm/dd/yyyy.

Is it the same principle with this as with currency you have just helped me
with?