Eric J. Hoffman wrote: > > Can anyone identify where to look in this instance?
> 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' This ine is the only line that could possibly have a division. If you have a problem with the quotes and a date in the year 2000 you get 1/1/0 which will throw an error. Can you show the CF code? Are you using cfqueryparam for all your variables? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:199800 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
