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:240342 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
