FormatNumber

[hubit]

HI

I am having troubles finding the right syntax
i have this syntax an it works fine but too many decimal places

response.write("<td align='right'>" + cstr(RS("TRANSPORTPRIS")&"") + "</td>")

I'm tryig to use Formatnumber cant make it work.
Hope someone has a suggestion

Thanks in advance

Jacob

 

[xwb]

Have you looked at

http://www.w3schools.com/vbscript/func_formatnumber.asp

Show us what you have tried with format number that doesn't work as you would like it.

 

[hubit]

I have tried a lot off kombinations
This
response.write("<td align='right'>" + cstr(RS("TRANSPORTPRIS")&"") + "</td>")
Works fine

Then i tried to kombine it with the FormatNumber

response.write("<td align='right'>" + FormatNumber(cstr(RS("TRANSPORTPRIS"))&""),2 + "</td>")
response.write("<td align='right'>" + Formatnumber(rs("TRANSPORTPRIS"),2) + "</td>")

 

[xwb]

FormatNumber requires a number: not a string. So if you want two decimal places, it would be

response.write("<td align='right'>" & FormatNumber(RS("TRANSPORTPRIS"),2) & "</td>")

The second one should have worked except possibly you used + instead of & for string concatenation. Use + for javascript, & for vbscript.

 

[hubit]

Ok there have been used + ind all the other lines
So when I use the (have tried the & as well
response.write("<td align='right'>" + FormatNumber(RS("TRANSPORTPRIS"),2) + "</td>")

I keep getting the error


Microsoft VBScript runtime error '800a000d'

Type mismatch: 'FormatNumber'

 

[xwb]

I think RS("TRANSPORTPRIS") returns a string. Try converting it to a double before formatting

response.write("<td align='right'>" & FormatNumber(cdbl(RS("TRANSPORTPRIS")),2) & "</td>")

 

[hubit]

New error

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'cdbl'

 

[hubit]

New error

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'cdbl'

 

[xwb]

Looks like RS(...) is NULL. Check that RS("TRANSPORTPRIS") is not null before writing it.

 

[gk53]

it is simple

if cstr(RS("TRANSPORTPRIS")&"")<>"" then 
response.write("<td align='right'>" &  FormatNumber(cdbl(RS("TRANSPORTPRIS")),2) & "</td>") 
else
response.write("<td align='right'></td>") 
end if

 

[ChrisHirst]

What's wrong with the IsNull() function?

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[guitarzan]

Also IsNumeric()

 

[hubit]

Hi

When I use the code from gk53 everything is workngust fine.

I haven't used th idNumeric() ane IsNull() funktion. I'l try them another day.

Thank you for all the help.

 

[gk53]

I use cstr(RS("TRANSPORTPRIS")&"")<>"" becouse isNull check for null value, but will not catch "" value it is not null, so you should have to chack for isNull() and cstr(RS("TRANSPORTPRIS"))<>"" or isNumeric().
IsNumeric() check just for numeric value and if it is null not catching that...
I think
if cstr(RS("TRANSPORTPRIS")&"")<>"" then

simpler then
if ((not isNull(RS("TRANSPORTPRIS"))) and isNumeric(RS("TRANSPORTPRIS"))) then

(extra parenteces just for readability)