Sql Server and VBScript decimal problem

[Chris Kennedy]

I am pulling a decimal value from SQL server and trying to use the format
currency and format number function. I am using these values in a large
string of HTML to be used in a CDONTS Email. If I use the code fragment
below the price variable, which is 3.92 in the database, shows up as £392.
When the formatcurrency is removed it is displayed as 3.92 but!!!! if I
concatenate a "£" it displays £392. I have read some posts about VBscript
not liking decimals, are there any ways around this. I have tried a
conversion to the money datatype, used a variety of csng and cdbl functions.
The odd thing is other numbers from the same column in the recordset format
correctly. The other thing is that variable 'price' is used elsewhere and
calculates correctly it seems VBscript just doesn't like converting it to a
string. Totally stumped!! Can anyone help.

HTML = HTML & "<td>" & formatcurrency(price) & "(&euro;" &
formatnumber(price*rate,2) & ")" & "</td>"

[Aaron [SQL Server MVP]]

[url]http://www.aspfaq.com/5003[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"Chris Kennedy" <chrisknospam@cybase.co.uk> wrote in message
news:eKOpTOieEHA.2396@TK2MSFTNGP11.phx.gbl...

> I am pulling a decimal value from SQL server and trying to use the format
> currency and format number function. I am using these values in a large
> string of HTML to be used in a CDONTS Email. If I use the code fragment
> below the price variable, which is 3.92 in the database, shows up as £392.
> When the formatcurrency is removed it is displayed as 3.92 but!!!! if I
> concatenate a "£" it displays £392. I have read some posts about VBscript
> not liking decimals, are there any ways around this. I have tried a
> conversion to the money datatype, used a variety of csng and cdbl

functions.

> The odd thing is other numbers from the same column in the recordset

format

> correctly. The other thing is that variable 'price' is used elsewhere and
> calculates correctly it seems VBscript just doesn't like converting it to

a

> string. Totally stumped!! Can anyone help.
>
> HTML = HTML & "<td>" & formatcurrency(price) & "(&euro;" &
> formatnumber(price*rate,2) & ")" & "</td>"
>
>