Did you try putting Val() around quantity and option_price, just to make sure CF isn't doing something funny?
> -----Original Message----- > From: Rick Root [mailto:[EMAIL PROTECTED] > Sent: Friday, May 12, 2006 9:47 AM > > 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 This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240350 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
