Ouch, that would be a bummer... Have you tried Float instead of Real? Isaac
> 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 >> >> > ______________________________________________________________________ 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
