linking table information

[Guest]

(Frontpage 2003). I am creating an online shop with prices shown in GBP
within a small table format next to each product. I would like to also show
the equivalent prices in US Dollars, Euros etc. that would be linked to a
background database (Excel?) so I can update the exchange rate in the
database which automatically updates prices on the web site without updating
each table manually and re-publishing the shop pages which costs money. Is
this easy to do or is there another way of acheiving the same result.

 

[Stefan B Rusynko]

Rather than the exchange rate in a DB use an ASP include page w/ a global variable
Your Include page (global.asp) is just

<%
Const currExc as double
currExc = 1.46426
%>

In your page include the page using

<!--- #INCLUDE FILE = "pathtofilehere/global.asp" --->

Then display the values using

<% MyCurrency - obRS("GBPprice") %>

<%=MyCurrency ' MyCurrency = 1000.00 %>

<%=MyCurrency*currExc ' MyEUCurrency = 1464.26 %>

PS
There are also online conversion links that will get you a current rate thru a link (search Google)
--




| (Frontpage 2003). I am creating an online shop with prices shown in GBP
| within a small table format next to each product. I would like to also show
| the equivalent prices in US Dollars, Euros etc. that would be linked to a
| background database (Excel?) so I can update the exchange rate in the
| database which automatically updates prices on the web site without updating
| each table manually and re-publishing the shop pages which costs money. Is
| this easy to do or is there another way of acheiving the same result.