I have a query which has static as well as dynamic columns. something like
below:
<cfset vMarks = "marks1, marks2, marks3">
<cfquery name="querymarks" datasource = "abc">
SELECT firstname, lastname,
<cfloop from="1" to="listlen(vMarks)" index="index">
marks_#index# <cfif #index# NEQ listlen(vMarks)>,</cfif>
</cfloop>
</cfquery>
The query result set will look like below:
firstname lastname marks1 marks2 marks3 ...
abc abc 112 113 114
def def 121 122 123
So when I am using coldfusion to display the above resultset I am doing the
below:
<table>
<tr>
<td>FIRST NAME</td>
<td>FIRST NAME</td>
<td>FIRST NAME</td>
</tr>
<cfoutput query="querymarks">
<tr>
<td>querymarks.firstname</td>
<td>querymarks.lastname</td>
<cfloop from="1" to="listlen(vMarks)" index="index">
<td>querymarks.marks_#index#</td>
</cfloop>
</tr>
</cfoutput>
</table>
The number of marks column is dynamic but I have a variable which stores the
list of marks. I am facing problem in displaying the marks with coldfusion. Can
anyone let me know if this can be done?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334382
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
