Whatever message this page gives is out now! Go check it out!
query = "query name"
border
colHeaders
colSpacing = "number of spaces"
headerLines = "number of lines"
HTMLTable
maxRows = "maxrows table"
startRow = "row number">
...
</cftable>Attribute | Req/Opt | Default | Description |
query | Required | Name of cfquery from which to draw data. | |
border | Optional | Displays a border around the table. If you use this attribute (regardless of its value), ColdFusion displays a border around the table.Use this only if you use the HTMLTable attribute. | |
colHeaders | Optional | Displays column heads. If you use this attribute, also use the cfcol tag header attribute to define them. If you use this attribute (regardless of its value), ColdFusion displays column heads. | |
colSpacing | Optional | 2 | Number of spaces between columns. |
headerLines | Optional | 2 | Number of lines to use for table header (the default leaves one line between header and first row of table). |
HTMLTable | Optional | Renders data in an HTML 3.0 table. If you use this attribute (regardless of its value), ColdFusion renders data in an HTML table. | |
maxRows | Optional | Maximum number of rows to display in the table. | |
startRow | Optional | 1 | The query result row to put in the first table row. |
returned from a query. --->
<!--- This query selects employee information from cfdocexamples datasource. --->
<cfquery name = "GetEmployees" dataSource = "cfdocexamples">
SELECT Emp_ID, FirstName, LastName, EMail, Phone, Department
FROM Employees
</cfquery>
<html>
<body>
<h3>cftable Example</h3>
<!--- Note use of HTMLTable attribute to display cftable as an HTML table,
rather than as PRE formatted information. --->
<cftable query = "GetEmployees"
startRow = "1" colSpacing = "3" HTMLTable>
<!--- Each cfcol tag sets width of a column in table, and specifies header
information and text/CFML with which to fill 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>