problem with struct containing query

[amiller]

Hello all- I've been having a re-occurring issue involving queries stored
within structures. I have a struct in which one of it's key's is a query. When
I try to loop the query using cfoutput an error occurs. Is this some sort of
bug, or am I just going crazy ? TIA, Aaron

<!--- this returns YES --->
#isQuery(application.department[dept].employees)#

<!--- this returns "Attribute validation error for tag cfoutput" --->
<cfoutput query="application.department[dept].employees)>

<!--- this returns "Comples object types cannot be converted to simple values"
--->
<cfoutput query="#application.department[dept].employees#)>

[MikerRoo]

Must be the 2nd option (or you're just tired). :-) You seem to have a syntax
error. IS: <cfoutput query='application.department[dept].employees)> Should
Be: <cfoutput query='application.department[dept].employees'> Regards, --
MikeR

[amiller]

Mike- Thanks for pointing that out. Unfortunately the typo is just in my
attached code. I had a bunch of other code in between that I didn't want to
post, so I just typed it. I've cut and pasted in another example, that is from
actual code that results in the errors I mentioned before. I'm still hoping
that I'm missing something here, I've just been looking at this code for so
long I can't figure it out... Thanks again, Aaron

<!--- returns YES --->
<cfoutput>isQuery ?
#isQuery(application.department[dept].employees)#</cfoutput>


<table cellpadding="0" cellspacing="0" border="0" width="175">
<!--- causes error --->
<cfoutput query="application.department[dept].employees">

[MikerRoo]

I new that was too easy! Anyway, it seems that CFOutput does not parse
arrays correctly. I couldn't get your code to work without the dreaded
Evaluate(). So use an intermediate variable. This can actually help debug
and has the advantage of allowing you out of the application variable CFLOCK,
that you are using (right?), quicker. Something like this: <CFSET
qryLclEmployees = application.department[dept].employees> <!--- Array
dereference in CFOutput does not work! ---> <cfoutput query='qryLclEmployees'>
Regards, -- MikeR

[amiller]

MikeR- Thanks again for the reply. Your idea worked just fine, however, I
must assume that this is a bug since simply copying the var into another var
works. Kinda defeats the purpose of having the information stored in the
application scope if I need to copy it into a local variable each time I want
to use it....Oh well, at least I now know I'm not completely nuts ! Thanks
again, Aaron