but CF forces a scale of zero having no other information about what scale
to use (well, it could calculate from the data). I would say this is a CF
bug.
CF_SQL_MONEY can usually be used with MSSQL Money because double and decimal
are often interchangeable, but not always. JDBC has no real concept of
Money which is stored internally as a long integer value to protect against
all possibility of rounding error that could happen with floating point
types.
I haven't validated all the data in the table, it's just based on what I was
able to gather from sparse available info on cf-java and java-other
mappings.
Best regards,
Sam
----------------------------------------------
Blog: http://www.rewindlife.com
Chart: http://www.blinex.com/products/charting
----------------------------------------------
-----Original Message-----
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 5:20 PM
To: CF-Talk
Subject: RE: cfqueryparam
It is great that someone compiled a table of translation. However, are you
sure about CF_SQL_NUMERIC? It doesn't correspond to MS SQL type numeric, MS
SQL allows for decimal point in its numeric while CF_SQL_Numeric doesn't. I
think CF_SQL_Numeric is more of an integer - or am I missing something here?
Also, CF_SQL_Money works fine with MS SQL type Money - maybe its because
JDBC type double works with MS SQL Money?.
TK
-----Original Message-----
From: Samuel Neff [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 4:49 PM
To: CF-Talk
Subject: RE: cfqueryparam
The CF_SQL_xxx types have a one-to-one mapping with JDBC SQL types which
are
easily identifiable (just take off the CF_SQL_). Only exception is money
which has no direct JDBC correspondent, so CF uses JDBC Double.
Based on that, I compiled this matrix:
http://www.blinex.com/~sam/CF_SQL_TYPES.cfm
HTH,
Sam
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
