Overview: run a cold fusion query against a datasource. Get a divide by zero error. Take that query in SQL Query analyzer and type in the query substituting values and it works fine. All values being input by cold fusion appear correct as well. Can anyone identify where to look in this instance? IN case it helps, resultant query: Select DISTINCT customer.id as cid, customer.business, customer_orders.id, SUM (customer_orders_prod.qty) as totunits FROM customer_orders JOIN customer on customer.id = customer_orders.customer_id JOIN customer_contact on customer.id = customer_contact.customer_id LEFT OUTER JOIN customer_orders_prod on customer_orders.id = customer_orders_prod.order_id JOIN inventory on customer_orders_prod.product_id = inventory.service_id WHERE customer_orders.orderdate BETWEEN '1/1/05' AND '3/1/05' AND customer_orders_prod.product_id = 101 AND customer_orders_prod.qty >= 1 AND customer.state = 'MN' AND (phone LIKE '%952%' OR phone LIKE '%651%' or Phone like '%763%' or Phone like '%612%') AND (business NOT LIKE '%HSR%' AND business NOT LIKE '%OSR%' AND business NOT LIKE '%HAS%' AND business NOT LIKE '%HAM%') AND customer.category <> 5 GROUP BY customer_orders.id, customer.id, business --------------------------------------------------------
Eric J. Hoffman Market Connections 2081 Industrial Blvd. Stillwater MN 55082 http://www.marketconnections.us T: 651.207.1526 F: 651.207.1536 M: 952.210.9060 E: [EMAIL PROTECTED] This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199796 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
