Tried before, same error. Thanks for the thought though. Also tried with tables fullname, same thing.
I guessed it's because Cost and Name are not the same datatype. But then one cannot always have the same datatype for all output. :( ----- Original Message ----- From: "Douglas Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 16, 2002 2:15 PM Subject: Re: CFMX & SQL - simple query with weird error message > Kinda weird, but try like so > > SELECT A.Name, B.Cost > FROM tableA a > INNER JOIN tableB b > ON (A.ID = B.aID) > WHERE B.aID = 1 > > > > > Douglas Brown > Email: [EMAIL PROTECTED] > ----- Original Message ----- > From: "Ye Wang" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, July 16, 2002 10:53 AM > Subject: CFMX & SQL - simple query with weird error message > > > > 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
