Ye, I am getting a VERY similar error. Did you ever get resolution on this issue?
I can solve my problem by setting up the DataSource in the CFAdmin as ODBC Socket connection instead of SQLServer... however I was thinking that JDBC is more efficient... faster etc. Brian At 10:53 AM 7/16/02, you wrote: >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 > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
