Database Results Wizard formatting Excel results

[KarenM]

I would like to have a number (i.e. $1,243 ) taken from my Excel
spreadsheet's total column appear on the homepage of my Frontpage 2003
website. I am able have the number appear (i.e. 1243) using ASP but it does
not have any formatting with commas or a dollar sign. I have tried to change
the formatting in Excel under the Style option and under formatting the cell.
It does not seem like it should be this difficult, am I missing something
simple ?

 

[Thomas A. Rowe]

On the page where you are displaying the number change the ASP tag to be similar to:

<%=FormatCurrency(fp_rs("fieldname"))%>

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

 

[Kathleen Anderson]

I haven't used Excel as a data source for the DBRW, but I've done the
formatting this way with Access:
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[KarenM]

Thank you for your reply. I am new to working with ASP and its code. Do you
know
where in the code the change/addition should be made.

Is this the tag that you were referring to change?
<%=FP_FieldVal(fp_rs,"sum")%>

I tried to change this tag and when I saved the page it overwrote my changes
and would not save them. Please let me know if I was in the right area.

Thank you !

 

[Thomas A. Rowe]

Ok, based on your example, the code would be enter like:

<%=FormatCurrency(FP_FieldVal(fp_rs,"sum"))%>

If you were hand coding.

However it appears that you are using FP DRW to generate your output, which I am not sure how your
would modify the code. Maybe Kathleen can assist you with this or better yet, follow her example.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

 

[Kathleen Anderson]

If you are changing code created by the DRW, you should make your changes to
the gray colored code and save the changes while still in Code view. You
will notice that once you've saved your changes they are also made to the
maroon colored code - that is by design. The maroon colored code should
never be touched; it's generated by the gray code at save time.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[KarenM]

Thank you for your help. I will try to make the changes in Excel. How do
you access the SQL in Excel to make the suggested changes?

 

[Ronx]

The SQL is in the web page, as Thomas and Kathleen described. Excel
acts as the database, and there is no SQL there to change.
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp

 

[Kathleen Anderson]

Hi Karen:
The link I gave is to instructions on how to modify the code generated by
the FrontPage Database Results Wizard.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[KarenM]

Thank you for your help, I was able to get the number to appear in currency
with the help of your suggestions. I was able to make the change in the Drop
Down Box Properties and as a result, it changed the code that appeared in
red. The dollar sign for the currency appears, but the commas look like
periods i.e. $1.234.00 Do you have any thoughts, also I would not even mind
getting rid of the zeros and just have a dollar amount ie. $1,234

Thank you, it is great to be able to find some info on this topic.
Karen

 

[KarenM]

FYI...
This is the code that I changed
<%=FP_FieldVal(fp_rs,"sum")%> to
<%=FormatCurrency(FP_FieldVal(fp_rs,"sum"))%>

it produced the results in Currency $1.233.00

Thank you for any suggestions!