I'm guessing it's a datatype problem. As a guess you could try a union all, since it would keep it from comparing every record in the second query to the first to eliminate dupes. How are these queries being created? Are the columns all identical data types? If you are creating them with querynew() are you specifying data types?
~Brad ----- Original Message ----- From: "Carl Von Stetten" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Wednesday, September 17, 2008 4:30 PM Subject: Re: Empty error message in a query of queries > 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:312738 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
