I am ready to admit defeat in creating a general solution to the problems in Query of Queries in 6.1 (guessed column types with QueryNew() queries etc).
The method I was trying, using WDDX to rewrite the column types, works great right up until a null is encountered in a number column. CFWDDX conveniently rewrites nulls as empty strings, thus stuffing up the number column in the recordset and causing a Java cast error when the column is sorted. I can make it work by putting a 0 in place of the null but that's completely useless. I've tried other methods (e.g. a temporary query crafted with the right guessed column types into which the original query's data is copied) and I end up with similar results (Java cast errors). QoQ is just too broken in 6.1 and upgrading to CF7 is the only way to make it really work reliably. Maybe that should be in the CF7 sales literature :-( ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212675 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
