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