A simple query against a SQL2000 database as follows:
select top 10
OrderID,ProductID,UnitPrice,Quantity,Discount,Amount
from [dbo].[Order Details]
order by OrderID desc
CFMX using JDBC for connection throws the following
err:
[Macromedia][SQLServer JDBC Driver]Value can not be
converted to requested type.
while SQL Analyzer executes fine and returns expected
resultsets.
Data type:
int(4), int(4), money(8), smallint(2), real(4),
real(4) NULLABLE (only this column)
SAMPLE DATA:
10248 11 14 12 0 168
10248 42 9.8 10 0 98
10248 72 34.8 5 0 174
10249 14 18.6 9 0 167.4
10249 51 42.4 40 0 1696
10250 41 7.7 10 0 77
10250 51 42.4 35 0.15 1261.4
What's going on?
I'd like to make 'friends' with CFMX but CFMX doesn't
seem to feel the same way, but we're in the same boat,
so, we are stuck together now.
Thanks.
DL
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
