Ben Nadel wrote: > I have never seen this specifically, but I have gotten similar errors when I > try to define a query with QueryNew() sending in data types... Are you using > QueryNew() to define any query that you are queryying?
Nope. contents is a query returned from a CFC, and both fields are numeric fields. Rick > -----Original Message----- > From: Rick Root [mailto:[EMAIL PROTECTED] > Sent: Friday, May 12, 2006 9:31 AM > To: CF-Talk > Subject: Query of Queries > > 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 > > Rick > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240321 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