Solved

Help dynamically build the table in coldfusion

Posted on 2008-06-24
2
165 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Sometimes databases have MILLIONS of records and we need a way to quickly query that table to return the results me need. Sure you could use CFQUERY but it takes too long when there are millions of records. That is why SOLR was invented. Please …
This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…

632 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