Strange Query Error

[Kapitaine]

Hi, I am wondering if anyone has ever encountered this query error before and if so, could provide any further information into what might be causing it.

---------------------------------------------------------------------------------------------------
Error casting an object of type java.lang.String cannot be cast to coldfusion.sql.QueryTable 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.
java.lang.String cannot be cast to coldfusion.sql.QueryTable
---------------------------------------------------------------------------------------------------

Now, It would be virtually impossible for me to describe my exact template setups here without us all getting very confused. I believe I have narrowed it down though to a query of queries on a query object being passed to this CFC. I have just never seen this error before and cannot find anything over the Internet or these forums.

Any assistance would be great.

Many thanks,
Michael.

[Daverms]

Hi Micheal,

QoQ's always tend to put a 'guess' kind of a datatype if you don't specify one..

Please go through these blogs..

http://www.bennadel.com/blog/568-Insane-ColdFusion-Query-Of-Queries-Madness-PLEASE-HELP-.htm
http://www.bennadel.com/blog/379-ColdFusion-Query-of-Queries-Unexpected-Data-Type-Conversion.htm

[Dan_Bracuk]

I see that error from time to time. It usually includes the template and line number so that I can troubleshoot it.