CFOUTPUT | |
Description
Displays the results of a database query or other operation. |
|
Category
Data output tags | |
Syntax<cfoutput query = "query_name" group = "query_column" groupCaseSensitive = "Yes" or "No" startRow = "start_row" maxRows = "max_rows_output"> </cfoutput> | |
See also
cfcol, cfcontent, cfdirectory, cftable |
|
History
New in ColdFusion MX: On Windows, if the cfdirectory tag action = "list", the tag does not return the directory entries "." (dot) or ".." (double dot), which represent "the current directory" and "the parent directory." (In earlier releases, it returned all the entries.) CFML code such as the following, which was acceptable in ColdFusion 5, might cause incorrect output in ColdFusion MX: <cfdirectory action = "list" directory="c:\" name="foo"> Files in c:\<br> <cfoutput query="foo" startrow=3> #name#<br> </cfoutput> CFML code such as the following, which was acceptable in ColdFusion 5, is acceptable in ColdFusion MX, although it is unnecessary: <cfdirectory directory="c:\" name="foo"> Files in c:\<br> <cfoutput query="foo" <cfif NOT foo.name is "." AND NOT foo.name is ".."> #name#<br> </cfif> </cfoutput>
|
|
Usage
To nest cfoutput blocks, you must specify the group and query attributes at the top-most level, and the group attribute for each inner block except the innermost cfoutput block. This tag requires an end tag. |
|
Example <!--- run a sample query ---> <cfquery name = "GetCourses" dataSource = "cfsnippets"> SELECT Dept_ID, CorName, CorLevel FROM courseList ORDER by Dept_ID, CorLevel, CorName </cfquery> <h3>cfoutput Example</h3> <p>cfoutput tells ColdFusion Server to begin processing, and then to hand back control of page rendering to the web server. <p>For example, to show today's date, you could write #DateFormat("#Now()#"). If you enclosed that expression in cfoutput, the result would be <cfoutput>#DateFormat(Now())#</cfoutput>. <p>In addition, cfoutput may be used to show the results of a query operation, or only a partial result, as shown: <p>There are <cfoutput>#getCourses.recordCount#</cfoutput> total records in our query. Using the maxRows parameter, we are limiting our display to 4 rows. <p><cfoutput query = "GetCourses" maxRows = 4> <PRE>#Dept_ID# #CorName# #CorLevel#</PRE> </cfoutput> <p>cfoutput can also show the results of a more complex expression, such as getting the day of the week from today's date. We first extract the integer representing the Day of the Week from the server function Now() and then apply the result to the DayofWeekAsString function: <br>Today is #DayofWeekAsString(DayofWeek(Now()))# <br>Today is <cfoutput>#DayofWeekAsString(DayofWeek(Now()))#</cfoutput> |
QUERY | |
Optional | |
Name of cfquery from which to draw data for output section. |
GROUP | |
Optional | |
Query column to use when you group sets of records. Use if you retrieved a record set ordered on a query column. For example, if a record set is ordered on "Customer_ID" in the cfquery tag, you can group the output on "Customer_ID." Case-sensitive. Eliminates adjacent duplicates when data is sorted. |
GROUPCASESENSITIVE | |
Optional | |
Default value: "Yes"
Boolean. Whether to group by case. If the query attribute specifies a query object that was generated by a case-insensitive SQL query. To keep record set intact, set to "No". |
STARTROW | |
Optional | |
Default value: "1 "
Row from which to start output. |
MAXROWS | |
Optional | |
Maximum number of rows to display. |