I am in the process of migrating an intranet application from CF 4.5 to CF MX. The database was originally created in Access 97.
I am using CFUPDATE to update some tables in the database and am having problems with filed type of “currency”.
Error Executing Database Query.Invalid data $2,234,565.00 for CFSQLTYPE CF_SQL_NUMERIC
This worked on the old server, but throws this error on the new one. Any ideas? The row has a lot of columns and CFUPDATE is far easier that the lengthy SQL to do the samething…
Eric
I am using the free version of SPAMfighter for private users.
It has removed 109737 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!
