tableA.ID and tableB.aID are both INT. No problem with that. Two ways I could make this query work. 1. change Cost datatype from Real to INT in SQL; 2. SELECT SUM(B.cost) AS cost;
Now with Solution 1, one has to user REAL datatype somehow, Cost is just a sample variable I used here. With Solution 2, I cannot select "A.Name" together with "B.Cost", unless I have some GROUP BY statement. However with large SELECT set sometimes one just doesn't want to use GROUP BY at all. Seems CFMX having problem retrieving REAL values from SQL?! I didn't have problem with INT in select statement. Or is this just a JDBC problem. This message of "Value can not be converted to requested type. " really confused me. ----- Original Message ----- From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 16, 2002 2:46 PM Subject: Re: CFMX & SQL - simple query with weird error message > Ye Wang 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) > > The datatypes of tableA.ID and tableB.aID are probably more relevant. > > Jochem > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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