Total stab in the dark but maybe you could try changing the alias for QUANTITY so it's not the same name as the column name itself? Maybe that's messing things up somehow.
-- Josh ----- Original Message ----- From: "Rick Root" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Friday, May 12, 2006 8:47 AM Subject: Re: Query of Queries > Anyone else got any ideas on this? "contents" is a regular query result > set, not anything made by QueryNew()... and the columns in question are > both numeric columns (quantity is an integer and option_price is a > decimal(10,2)... mysql database) > > Rick > > Rick Root wrote: >> I'm getting the following error: >> >> Query Of Queries runtime error.</b><br> Cannot apply the binary numeric >> operator [*|/] on a non numeric type >> >> When running the following query of queries: >> >> select >> sum(QUANTITY) AS QUANTITY, >> SUM(QUANTITY*OPTION_PRICE) AS MERCH_CHARGE >> FROM contents >> >> I dumped the contents of the "contents" query and both "QUANTITY" and >> "OPTION_PRICE" contain numeric values. >> >> I've never seen this error before and this code hasn't changed from a >> previous installation of the same code on a different server. >> >> This server is at smarterlinux, it's coldfusion mx 7 7,0,1,116466 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240352 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
