Brent, Without seeing the two queries that your are joining together, I can only guess at the problem. Likely, one of the columns in qReportSummary doesn't match the datatype of the corresponding column in qSummary, or you don't have the same number of columns in both queries.
HTH, Carl Brent Shaub wrote: > 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:312721 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4