OR to remove the evaluate function call.
>
> <cfoutput query="qry">
> #qry[listGetAt(qry.columnlist,2)]#
> </cfoutout>
That would be great, if it worked. Query objects cannot be accessed like
structures. Query columns can (qry.col[row]), but not the query itself. Throws
a "Complex object types cannot be converted to simple values" error in CFMX7.
-Justin Scott
Sorry, that's what I get for suggestion code without testing it. If one uses
array notation, they must note complete, column and row. This works as test on
6.1. Should also work on 7, but I have not upgrade my workstation yet. All
three methods output the same value from my test query.
<cfoutput query="test">
#test.factoid#<br/>
#test['factoid'][currentRow]#<br/>
#test[listGetAt(test.columnList,2)][currentRow]#<br/>
<br/>
</cfoutput>
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222961
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
