Here's the beginning of the error message for a query of queries: Message [empty string]
StackTrace java.lang.ClassCastException at coldfusion.sql.imq.GenericComparator.compare(Comparator.java:67) at coldfusion.sql.imq.TableSorter.compareTo(TableSorter.java:156) at coldfusion.sql.imq.TableSorter.compareTo The query of queries goes: <cfelseif qSelectReports.currentrow gt 1> <cfquery name="qReportSummary" dbtype="query"> select * from qSummary union select * from qReportSummary </cfquery> The query has worked for months until today. It continues to work for certain report summaries, but not in this one in particular. I'm thinking it's because of the data specific to that report. Anyone know of any special characters to look out for which might be causing the failure in the QofQ? "(" ? So glad to have this forum to post to so; I'd like to keep my hair, Brent ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4