I have created a structure and then converted it into a recordset so I can select by specific criteria. However, I can not figure how in the world to add arguments to limit the select statement, for everything I do throws "Query Of Queries runtime error.
Unsupported Numeric type conversion in Query of Queries. "

<CFQUERY NAME="GetMarketingEvents" dbtype="query>
SELECT * FROM EventsRecordset
Where EventType = 1
</cfquery"">

Can anyone offer any guidance? Workarounds? Solutions? This sucks! Thanks.

Last Edited clearin on 27-Feb-2006 12:37 PM

Apparently, when doing a Query of Query against a query created using the QueryNew() function, CFMX guesses what the datatype is for each column based on the data in the first row.

So if your Query of Queries sees an integer in the first column of the first row, and then sees a string in the first column of the second row, CFMX will throw an error that says it cannot convert the datatype to another datatype.

Interesting, I explored that workaround, but it didn't help.

WHERE EventType = '1'

----------
MyWebCaster.com

Doesn't matter if I populate the array before adding it as a column with strings, ints, javacasted values... 7.1 latest hotfixes (this isn't listed as an issue in any of them).

Must be somesorta hard-to-reproduce error. If I figure it out I'll holler.