Hello
BACKGROUND:
I have designed a 'Transform' query as part of an intranet usage reporting
tool. I display the user, the total number of hits, and then the hits per
page. When someone runs this report, they have the option to limit the
pages reported on - ie only the general pages, only the admin pages...
Therefore, the query will have a different number of columns, and different
column headings.
If I CFDUMP the query, the results display correctly, but I don't have any
control over layout.
Therefore, what I want to do is output the data myself.
THE PROBLEM:
How do I programatically output query data, using the values in
query.ColumnList?
I have done a search in the archives, and found this example which I have
been unable to get to work:
<cfloop list="#Stats.ColumnList#" index="Cols">
<cfset currentColumn = Evaluate("Stats" & Cols)>
#currentColumn #
</cfloop>
(where Stats is my query name)
I get an error like this:
An error occurred while evaluating the expression:
currentColumn = Evaluate("Stats." & Cols)
Now, it could be that the error arises when the column name includes spaces
(eg Budget Report).
Can someone give me some tips about this before I go back and take all the
spaces out of the existing data and modify my hit-recording code?
Is there a way to refer to a column by a number? eg Stats.[1]?
If you can make any sense out of the above and can advise me I would be most
grateful.
(I'm using CF5.0)
Thanks
Antony
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
