Fantastic!
> ><cfloop query="stats"> > <cfloop list="#Stats.ColumnList#" index="currentColumn"> > #stats[currentColumn][currentrow]# > </cfloop> ></cfloop> > > > -----Original Message----- > > From: Antony Sideropoulos [mailto:[EMAIL PROTECTED] > > Sent: Friday, 4 April 2003 2:12 p.m. > > To: CF-Talk > > Subject: Referring to 'unknown' query columns > > > > 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
