That did it.
----- Original Message -----
From: Pascal Peters
To: CF-Talk
Sent: Wednesday, January 21, 2004 12:03 PM
Subject: RE: Problems with Text in Access
Looking at the error message, I suspect you have NULL values in that
column. You have to take care of that before using dollarformat. It is
most likely not an Access issue.
<cfif IsNumeric(val)>
#DollarFormat(val)#
<cfelse>
#val#
</cfif>
> -----Original Message-----
> From: Mickael [mailto:[EMAIL PROTECTED]
> Sent: woensdag 21 januari 2004 17:34
> To: CF-Talk
> 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]
