Do any parts of the query work? Meaning, If you run with just the first SUM directive does it work? Does it work if you do not do the "*" in the second SUM? Let's see if we can narrow it down to exactly what is breaking?
....................... Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 212.691.3477 fax www.nylontechnology.com "You know, like nunchuck skills, bowhunting skills, computer hacking skills... Girls only want boyfriends who have great skills." - Napoleon Dynamite -----Original Message----- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 11:47 AM To: CF-Talk 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:240347 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