Would the following strategy help? Maxrows the query to 10 and see if it works then, if it does then yes it sounds like a value is causing a problem, if it doesn't then it must be something else.
If 10 records does work try the first 100, then the first 1000 etc. Shouldn't take too long to pin down the problematic value by retrieving subsets of the data. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326479 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
