Solved

Help dynamically build the table in coldfusion

Posted on 2008-06-24
2
161 Views
Last Modified: 2013-12-24
I have a list of courses,(which is dynamic rign now 2 courses but could be more). I Nedd to check the completion for that courses and output it into the HTML table. First i am trying to loop through the courses and get the completion, and then output it into the table

But unfortunately it did not work
 

lcourse is list of courses
<cfloop from="1" to="#ListLen(lcourse)#" index="i">

	<!---	<cfset qName="checkCompletion" &i>--->

			<cfquery name="qName" datasource="cfelsunrise" dbtype="ODBC">

				Select completiondate from EmployeeTraining where EmployeeID=#EmployeeID# and courseID in (#lcourse#)

			</cfquery>
 

	</cfloop>

	<cfloop from="1" to="#ListLEn(lcourse)#" index="i">

	<td align="center" width="2%" <cfif qName.completiondate is not "">bgcolor="##00FF00"<cfelse>bgcolor="##FF0000"</cfif>></td>

	

	</cfloop>

	</tr>

	

	</cfoutput>

Open in new window

0
Comment
Question by:erikTsomik
2 Comments
 
LVL 4

Expert Comment

by:JillofallTradesMistressofNone
ID: 21857820
Hi.   Where is your opening cfcoutput tag?  Is it just not in this code sample?  Check out this page for help on cfloops and output:  http://www.quackit.com/coldfusion/tutorial/coldfusion_loops.cfm

Good luck!
0
 
LVL 2

Accepted Solution

by:
adobe116 earned 500 total points
ID: 21862473
Hey, I think you want to delete lines 7 and 8.  You should only loop through the list once.

Also, instead of checking to see if something equals "", simply check if it's length is > zero.

I changed that in your code.  Best of luck.
<cfoutput>

<table>

<tr>

<cfloop from="1" to="#ListLen(lcourse)#" index="i">

	<!---	<cfset qName="checkCompletion" &i>--->

	<cfquery name="qName" datasource="cfelsunrise" dbtype="ODBC">

	Select 

		completiondate 

	from 

		EmployeeTraining 

	where 

		EmployeeID = #EmployeeID#

		and

		courseID in (#lcourse#)

	</cfquery>

 

	<td align="center" width="2%" <cfif len(qName.completiondate)>bgcolor="##FF0000"<cfelse>bgcolor="##00FF00"</cfif>>#yourContent#</td>

</cfloop>

</tr>

</table>

</cfoutput>

Open in new window

0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
Hi, Even though I have created this Tutorial on My personal Blog, Some people might not able to find my website, So here i am posting it again Today, from the topic it is very clear that i will be showing you here the very basic usage of how we …
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now