It was a dollar amount from a MONEY datatype (MSSQL) field in a db. But
some math was done on it. It now has precision of 4 or even more. Ie
126.9401. When trying to insert it back into a MONEY field I get the
error:
[SQL Server]Disallowed implicit conversion from data type varchar to
data type money, table 'PnP-Dev.dbo.onlinepay', column 'AmountPay'. Use
the CONVERT function to run this query.
Here's my code:
<cfqueryparam value="#numberformat(attributes.pmt_total_fees,
'_____.99')#" cfsqltype="CF_SQL_MONEY">,
I've tried it without the cfqueryparam just the
#numberformat(attributes.pmt_total_fees, '_____.99')# with or without
quotes. Always the same error.
Help?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
