Re: Empty error message in a query of queries
Thanks for the replies Carl and Brad. Turns out you're both on the right track. The query is the same as it loops over various databases and appends the results using the QofQ. There is no chance of the records being the same since they are in different databases and one of the columns is the database name. The "union all" seems like a perfect. It worked immediately. I never knew about this option. Thank you, Brad. Carl, there were 45 columns in the query and not having to specify them all was the solution I opted for. Detailing their types may have worked just as well. Thanks again for your help. 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:312761 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Empty error message in a query of queries
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" 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
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
>
>
> The query of queries goes:
>
>
> select * from qSummary
> union
> select * from qReportSummary
>
>
> 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
Empty error message in a query of queries
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:
select * from qSummary
union
select * from qReportSummary
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
