This wouldn't make much sense, but maybe it's that one is int and one is float... Try putting in
SUM(1.0 * OPTION_PRICE) AS MERCH_CHARGE - and - SUM( 1 * OPTION_PRICE ) AS MERCH_CHARGE This way we will see if that breaks. If the 1 still breaks but the 1.0 does not break, then it's a casting issue?? ....................... 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 12:48 PM To: CF-Talk Subject: Re: Query of Queries Ben Nadel wrote: > 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? It is definately this one causing the problem: select SUM(QUANTITY*OPTION_PRICE) AS MERCH_CHARGE FROM contents Both values are numeric (I output #isNumeric(contents.QUANTITY)# and #isNumeric(contents.OPTION_PRICE)# The values are 1 and 16.99 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240361 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