I l @ ve RuBoard |
<CFOUTPUT>Used with queries and variables to display information from ColdFusion. Before a user can see information that's been processed by ColdFusion, you must first use <cfoutput> to make that information visible to the user. Syntax<cfoutput query="nameofquery" group="columntogroupby" groupCaseSensitive="Yes" or "No" startRow="rowtostarton" maxRows="maximumrowstooutput"> </cfoutput> Attributes>Query: Optional. This attribute specifies the recordset to be output. It corresponds to the name of the query in the <cfquery> tag. Group: Optional. If you used the ORDER BY operator in your SQL statement to order the query by a specific field, like productID, the Group attribute will group the records together so all of the adjacent records will be removed. GroupCaseSensitive: Optional. The default value is yes. This attribute determines whether or not the group attribute is case sensitive. StartRow: This is the row on which you wish to start outputting your query. MaxRows: Specifies the maximum number of rows output. ExampleFor Variables: <!--- create a variable to hold the user's name ---> <cfset name = "Andrew Walter Schmidt"> <!--- Output the variable ---> <cfoutput> #name# </cfoutput> For Query: <cfquery name="productlist" datasource="products"> SELECT * FROM tblProducts </cfquery> <cfoutput query="productlist"> #ProductName#<br> </cfoutput> |
I l @ ve RuBoard |