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

Reply via email to