Query of queries Error

[Tulsa]

I am putting query results into a new query to sort them, rather than using
arrays. I can insert into a new query using queryNew just fine and even
display the results fine. The error comes when I try query the query. Here is
the error:

Query Of Queries runtime error.
Unsupported Numeric type conversion in Query of Queries.

The error occurred in
E:\Inetpub\wwwroot\developers\brown\abxy_match\fin d_match.cfm: line 73

71 :
72 :
73 : <cfquery dbtype="query" name = "mattQuery2">
74 : SELECT *
75 : FROM mattQuery




--------------------------------------------------------------------------------

SQL SELECT * FROM mattQuery

Here is the relevant code. Thanks for any help.

<cfset mattQuery = QueryNew("Store, Part, Description, qty, Sales, Value")>
<cfset newRow = QueryAddRow(mattQuery, get.recordcount)>
<cfoutput query="get">

<cfquery name="chk_others" datasource="myrmps">
select is_store, sum(rs_q1 + rs_q2 + rs_q3) as q_sales
from invs, rinvs
where is_store = rs_store
and is_part = rs_part
and is_dead in ('A','B')
and is_part = '#get.is_part#'
and ((rs_q1 + rs_q2 + rs_q3) / #get.is_qty#) >= #rate#
group by 1
order by is_store
limit 1
</cfquery>


<cfset temp = QuerySetCell(mattQuery, "Store", chk_others.is_store,
get.currentrow)>
<cfset temp = QuerySetCell(mattQuery, "Part", get.is_part, get.currentrow)>
<cfset desc = trim(get.i_desc) & trim(get.i_desc2)>
<cfset temp = QuerySetCell(mattQuery, "Description", desc, get.currentrow)>
<cfset temp = QuerySetCell(mattQuery, "qty", get.is_qty, get.currentrow)>
<cfset temp = QuerySetCell(mattQuery, "Sales", chk_others.q_sales,
get.currentrow)>
<cfset t_dollars = get.is_wac * get.is_qty>
<cfset temp = QuerySetCell(mattQuery, "Value", t_dollars, get.currentrow)>

</cfoutput>



<cfquery dbtype="query" name = "mattQuery2">
SELECT *
FROM mattQuery
ORDER by Store
</cfquery>

[Tulsa]

Sorry to answer my own question but I found a workaround in the MM forums.
Here is the link


[url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=6&thread[/url]
id=796067&enterthread=y

I had to turn all values being inserted into the new query into strings by
concatenating a "".