both FLOAT and INT are working, but not REAL.
----- Original Message ----- From: "S. Isaac Dealey" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 16, 2002 3:07 PM Subject: Re: CFMX & SQL - simple query with weird error message > 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 > >> > >> > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
