scope) instead of going back to the database and repeating the query. The
main problem is that the order of the query matters since I am using the
group attribute of cfoutput. The query needs to be ordered by date. The
QueryAddRow function can add a row to the end of the query, which means I
need to take the extra step of reording the query by date. When I try to
reorder the query using a QoQ with an order by clause, I get the error:
"Error casting an object of type to an incompatible type. This usually
indicates a programming error in Java, although it could also mean you have
tried to use a foreign object in a different way than it was designed. "
<cfquery name="this.active.qDailyData" dbtype="query">
SELECT * FROM this.active.qDailyData ORDER BY ActivityDate
</cfquery>
So, is there any way to efficiently add a new row to a specific point in
the middle of an existing query?
Thank you,
Mike Chabot
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
