Ian Skinner wrote: We are also using Oracle here as well. Your idea would probably work, except Queries of Queries only supports inner joins. A limitation I have butted heads with on several occasions.
Bummer. I can't think of a query-returning option, then. I would pull all the Oracle data into queries or maybe one query, then loop over my date range and check against the pulled query results as I went. Not neat, I'm afraid. Good luck. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:223087 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