PS. The error is actually references this code, which follows that below
"
<CFQUERY NAME="GetBigTrails" dbtype="query">
SELECT Trail, CustID
FROM Holder
WHERE Trail > 150
ORDER BY Trail DESC
</CFQUERY>
"
> Thanks Ben, Mark and Gary (see previous thread).
> I'm trying out QueryNew and Query Of Queries.
>
> And here's my first error.
>
> "Query Of Queries runtime error.
> Unsupported type comparison."
>
> I've followed the form of the example code in the CFMX manual
> i.e.
>
> <cfset Holder = queryNew("Trail, CustID")>
> <cfset TheBuffer = 100000>
> <cfset newrow = queryAddRow(Holder,#TheBuffer#)>
>
> and
>
> <cfset RowNum = 1>
> <cfloop query1>
> <cfloop query2>
> <cfset temp = querySetCell(Holder,"Trail","#SumTrail#","#RowNum#")>
> <cfset temp = querySetCell(Holder,"CustID","#CustID#","#RowNum#")>
> <cfset RowNum = RowNum + 1>
> </cfloop>
> </cfloop>
>
> The only thing which appears to differ from the sample code is that I've
> placed the SetCell command inside 2 nested loops. Could this be an issue ?
>
> Or is the "type comparison" to do with data types ?
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
