We just installed CFMX on a brand new server, W2k with SQL 2000. Most
CF5 codes worked and no problems with stored procedures so far, except a
few errors on simple queries. One of them was quite weird.
Name : VARCHAR(128)
Cost: real
tableA joins tableB on (tableA.ID = tableB.aID)
Case 1: works
<cfquery name="get_a" datasource="myDSN">
SELECT ID, Name
FROM tableA
</cfquery>
Case 2: works
<cfquery name="get_b" datasource="myDSN">
SELECT aID, Cost
FROM tableB
WHERE aID = 1
</cfquery>
Case 3: NOT working in CFMX but in CF5 and old versions
<cfquery name="get_ab" datasource="MyDSN">
SELECT A.Name, B.Cost
FROM tableA AS A INNER JOIN
tableB AS B ON (A.ID = B.aID)
WHERE B.aID = 1
</cfquery>
CFMX Error message:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]Value can not be converted to
requested type.
Now Case 3 is too simple to cause errors. If CFMX can handle more
complicated queries and stored procedures but not this one, it's just
hard to understand. Maybe something too simple?! I've tried many things
but cannot fix it. Can anyone throw some light on this? Thx
-Ye
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
