Builds a table in your ColdFusion page. Use the CFCOL tag to define column and row characteristics for a table. CFTABLE renders data either as preformatted text, or, with the HTMLTABLE attribute, as an HTML table. Use CFTABLE to create tables if you don't want to write your own HTML TABLE tag code, or if your data can be well presented as preformatted text. See Usage for information about using the CFCOL tag with the CFTABLE tag.
<CFTABLE QUERY="query_name" MAXROWS="maxrows_table" COLSPACING="number_of_spaces" HEADERLINES="number_of_lines" HTMLTABLE BORDER COLHEADERS STARTROW="row_number"> </CFTABLE>
Required. The name of the CFQUERY from which you want to draw data.
Optional. Specifies the maximum number of rows you want to display in the table.
Optional. Indicates the number of spaces to insert between columns (default is 2).
Optional. Indicates the number of lines to use for the table header (the default is 2, which leaves one line between the headers and the first row of the table).
Optional. Renders the table as an HTML 3.0 table.
Optional. Adds a border to the table. Use only when you specify the HTMLTABLE attribute for the table.
Optional. Displays headers for each column, as specified in the CFCOL tag.
Optional. Specifies the query row from which to start processing.
You can use the CFCOL tag to align the data in the table , specify the width of each column, and provide column headers.
Note | CFCOL is the only tag that you can nest within CFTABLE. |
<!--- This example shows the use of CFCOL and CFTABLE to align information returned from a query ---> <!--- This query selects employee information from the cfsnippets datasource ---> <CFQUERY NAME="GetEmployees" DATASOURCE="cfsnippets"> SELECT Emp_ID, FirstName, LastName, EMail, Phone, Department FROM Employees </CFQUERY> <HTML> <HEAD> <TITLE>CFTABLE Example</TITLE> </HEAD> <BODY> <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> <!--- 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>