Thanks, Andrew, Nope, not using cachewithin or cachedafter in any of the queries (unless that's something that is hidden in there by default).
I am using v7.0.1 at this moment. I'm going to upgrade to 7.0.2 soon. Is this an issue with 7.0.1? I have set the Maximum number of cached queries to 0 in CF Admin, restarted IIS, restarted all CF services and the query ran fine... once. After it ran, I modified the table and back to the "value cannot be converted to the requested type error". I have unchecked the Maintain Connection associated with the datasource... Thanks for your ideas. I hope something soon works. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254605 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
