I've tried to modify the SQL atatement to do this but all efforts proved unsucessful. So i tried this...

<%FormatCurrency(FP_FieldVal(fp_rs,"TotalNet"))% >

That worked, but when the field contained a null I would recieve a VB Script error...


Microsoft VBScript runtime error '800a000d'

Type mismatch: 'FormatCurrency'

/test1.asp, line 26


So I tried this next...

<%If FP_FieldVal(fp_rs,"TotalNet") > NULL Then Response.write FormatCurrency(FP_FieldVal(fp_rs,"TotalNet"))%>

It looked like it worked at first but I later found that it returns nothing even if there is something to return.

So my brain is fried... Can anyone see what I am doing wrong here?

you can't compare null values like that,.. try this...

It does work if there is a value to return. But it still does not work if it returns a null. I get this...


Microsoft VBScript runtime error '800a000d'

Type mismatch: 'FormatCurrency'

/test.asp, line 26

Any other thoughts. BTW thank you for your input.

It makes me think that as well as nulls you have blanks....

try
btw what does the FP_FieldVal function actually do??

First, depending on the complexity of FP_FieldVal, then you might want to call that function and store the return in a variable instead of calling it twice.

I agree with rokslide.. can we see what that function does?

I thank you for your responses, However I managed to figure it out with help from my friend. Here is what I came up with...

<% IF Trim(FP_FieldVal(fp_rs,"TotalNet")) = "&nbsp;" THEN
Response.write ("$0.00")
ELSE
Response.write (FormatCurrency(FP_FieldVal(fp_rs,"TotalNet")))
END IF%>

I used Trim to remove the space that FP_FieldVal returns when the field is Null. Then I through in an "ELSE" because it seemed logical.

Again I thank you for your efforts.

Personally I'd rewrite that FP_FieldVal function it seems like a slightly silly way of doing things if I am guessing what it is doing correctly.