For example I may have 3 courses . so i want to dynamically generate the query
and fill the result into the <td>THe number of courses can change that why I
need to dynamically generate the queries
I came up with code but does not seems to be working
<cfoutput query="getReport">
<tr>
<td>#erLastName#,#erFirstName#</td>
<td>#eaLastName#,#eaFirstName#</td>
<td>#locname#</td>
<td>#empLastName#,#first_name#</td>
<cfloop from="1" to="#ListLen(lcourse)#" index="i">
<cfquery name="checkCompletion#i#"
datasource="cfelsunrise" dbtype="ODBC">
Select completiondate from EmployeeTraining
where EmployeeID=#EmployeeID# and courseID in (#lcourse#)
</cfquery>
<cfloop query="checkCompletion#i#">
<td align="center" width="2%" <cfif completiondate neq
"">bgcolor="##00FF00"<cfelseif completiondate eq
"">bgcolor="##FF0000"</cfif>></td>
</cfloop>
</cfloop>
</tr>
</cfoutput>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308043
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
