VBScript error 1.#QNAN & $1.#R

[Ladyborg]

Shopping cart has new vbscript errors: 1.#QNAN & $1.#R
Also sometimes say "microsoft vbscript runtime error '800a000d'" and "type mismatch: 'formatcurrency".

Code in question:
<%= FormatCurrency((UCCart1.GetColumnTotal(&quot;Total&quot), 2, -2, -2, -2) %>

I've worked this out a zillion different ways, although I see no error in it, and just can't make it work. It was working fine until a few days ago, don't know how or what was messed up! Ladyborg
&quot;Don't be afraid to try new things,
Remember: professionals built the Titanic, amateurs built the Ark&quot;

 

[Cheech]

Looks like you are trying to format a nonnumerical field.

Have any of the records got a $ £ or whatever currency symbol already in? The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)

 

[Ladyborg]

It is a numerical field, and the database fields are formatted to currency, so does that answer your question? I've tried t both ways, (both with the DB currency and non-currency formats) and get the same (or similar error).
Ladyborg
&quot;Don't be afraid to try new things,
Remember: professionals built the Titanic, amateurs built the Ark&quot;