<!--- This example shows the use of CFCOL and CFTABLE
to align information returned from a query --->

<!--- this query selects employee information from the
snippets datasource --->
<CFQUERY NAME="GetEmployees" DATASOURCE="cfsnippets">
SELECT      Emp_ID, FirstName, LastName, EMail, Phone, Department
FROM         Employees
</CFQUERY>

<HTML>
<HEAD>
<TITLE>CFTABLE Example</TITLE>
</HEAD>

<BASEFONT FACE="Arial, Helvetica" SIZE=2>
<BODY  bgcolor="#FFFFD5">

<H3>CFTABLE Example</H3>
<!--- Note the use of the HTMLTABLE attribute to display the
CFTABLE as an HTML table, rather simply as PRE formatted information --->
<CFTABLE QUERY="GetEmployees" STARTROW="1" COLSPACING="3" HTMLTABLE COLHEADERS>
<!--- each CFCOL tag sets the width of a column in the table,
as well as specifying the header information and the text/CFML
with which to fill the cell --->
	<CFCOL HEADER = "<B>ID</B>"
		ALIGN = "Left"
		WIDTH = 2
		TEXT  = "#Emp_ID#">
	<CFCOL HEADER = "<B>Name/Email</B>"	
		ALIGN = "Left"
		WIDTH = 15
		TEXT  = "<a href='mailto:#Email#'>#FirstName# #LastName#</A>">
	<CFCOL HEADER = "<B>Phone Number</B>"
		ALIGN = "Center"
		WIDTH = 15
		TEXT  = "#Phone#">
</CFTABLE>

</BODY>
</HTML>       
