$ signs

[Buzby]

Hello all. I'm reasonably new to ASP so be gentle with me.
I am trying to display an amount in pounds sterling; eg

£100.00

I have a MONEY field in a SQL Server database, but whenever I try and display it in ASP I get it in dollars;

$100.00

I have been using the FormatCurrency function - is there a better way. I have checked both the server and the client PC for regional settings, and they are both set to £ signs. Are there some other settings in IIS that determine the currency symbol etc..?
Please help - this is driving me mad.

[Ianpbaker]

Hi Buzby

According to SQL books Online, you need to pas the currency sign in as well and then it will return ti in the same currency.

Hope this helps

Ian

[Buzby]

So... where would I put the £ sign in this example;

Response.Write "<TD ALIGN=CENTER>"+cstr(formatcurrency(Gridrs("calcamount")))+"</TD>" & vbNewLine

??

I've tried;

Response.Write "<TD ALIGN=CENTER>"+cstr(formatcurrency("£"+Gridrs("calcamount")))+"</TD>" & vbNewLine

but I just get a Type Mismatch error. Why can't ASP have VB's Format function - then I could just do

Response.Write "<TD ALIGN=CENTER>"+cstr(format(Gridrs("calcamount"),"Currency"))+"</TD>" & vbNewLine


And, also on the same subject I can't get it to display a Date in English (dd/mm/yyyy) format - again this is regardless to what is set in the regional settings in the Control Panel.

I'm using;

Response.Write "<TD ALIGN=CENTER>"+cstr(formatdatetime( Gridrs("paydate"),2))+"</TD>" & vbNewLine

where the '2' is meant to output the date in the Windows 'Short' format - which is set on the client and the server as dd/MM/yyyy

Any ideas?

[Ianpbaker]

From what I said, you are looking at it from the wrong side. The pund sign has to be in the SQL field that your grabbing the data from

Ian