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
