Query of Queries of ArrayNew?

[cf_code_warrior]

I am very familiar with query of queries. But I think, maybe, I just
realized, you cannot create (in MX 6.1) a query of queries of a query that was
created using queryNew function? Can't be? Please? Any workarounds other
than ANOTHER queryNew kludge? I get an error ... Query Of Queries runtime
error.</b><br> <br><b>Query Of Queries runtime error.</b><br> Unsupported
Numeric type conversion in Query of Queries. And now this messge board is
crashing! Thanks, Robert

[TA-Selene]

I have found this to be true as well. Nor can you query of query a result set
that is stored in application or session scope. From my experience, the query
result must have been generated by cfquery, cfhttp, cfldap, etc.... and have
been physically run in the same page request as the query of query. <sigh>

[Adam Cameron]

> I have found this to be true as well. Nor can you query of query a result set

> that is stored in application or session scope. From my experience, the query
> result must have been generated by cfquery, cfhttp, cfldap, etc.... and have
> been physically run in the same page request as the query of query. <sigh>

This is not the case at all. I do both, on a daily basis: QoQ a
queryNew()-created query which is stored in the application scope.

The OP's problem sounds like they've got nulls somewhere inconvenient to CF
(which would be almost anywhere, given how inconvenient CF finds nulls).

That said, I have also found one has to muck around with the
queryNew()-contrived query to get it to have the correct datatypes for its
columns - CF has to guess: something else it's pretty piss poor at.

The bottom line is... yes, you're right: you're going to have to kludge
about the place to get it to work.

Or throw your hands in the air in despair and effect your results some way
other than QoQ. Which is what I find myself doing in 6.1 quite a lot.

CF7 should be better... I was on the beta program (surely that's not
breaking the NDA?) and I tend to complain when I don't get my own way, if
you know what I mean ;-)

--

Adam

[cf_code_warrior]

Adam Thanks for giving this old git a laugh for today. I too was on the 7
(Blackstone) beta. Have yet to deploy it to production for a) fear and b)
laziness. Oh and C) not bought a production license! I ended up doing another
array. Sod it! It was a 10 second workaround. Yes, the application scoped
var that I start with has nulls in it. But,. come on, that should not have to
work like the IRS. Anyhoooooo, got my problem solved for that hour. Did YOU
go production on 7.0? Might even go there this week. Robert

[Adam Cameron]

> Did YOU

> go production on 7.0?

Nope.

Having been bitten on the bum quite profoundly by adopting 6.0 immediately
and then having to uncode a lot of work-arounds once 6.1 appeared, I
personally am going to hold off until 7.1.

That said, I don't make all the decisions around here, and I think the boss
wants to get his teeth into <cfdocument>, so we might have to jumps sooner
than that.

--

Adam