Should there be some sort of argument in the cfif ? Like =0?
----- Original Message -----
From: Deanna Schneider
To: CF-Talk
Sent: Wednesday, January 21, 2004 12:03 PM
Subject: Re: Problems with Text in Access
It's failing on a null. If you want no value to show up as $0.00, then you
can do something like so:
<cfif len(trim(yourdollarfield))>
#dollarformat(yourdollarfield)#
<cfelse>
#dollarformat(0)#
</cfif>
----- Original Message -----
From: "Mickael" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 21, 2004 10:34 AM
Subject: Problems with Text in Access
> Hello,
>
> I have a problem with an Access database. I cannot switch to another
database. The problem is that there were numerical values being stored as
text. I am getting errors with I try to use Dollarformat() so I modified
the database column to be numeric, imported the database tables in to a new
table with Name AutoCorrect off.
>
> This doesn't help I still get this error.
>
>
> Parameter 1 of function DollarFormat which is now must be a number
>
>
>
> I would like to fix the access issue. But if not is there a way to take a
string that is a number and convert it to a number then display it properly
as a dollarformat?
>
>
> Thanks
>
> Mickael
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
