Article

Get Started with ColdFusion

Page: 1 2 3 4 5

Tag and Function Reference

<CFOUTPUT></CFOUTPUT>
Displays the output of a database query, variable or other operation.

Syntax:

 <cfoutput      
 query = "query_name"    
 group = "query_column"    
 groupCaseSensitive = "Yes" or "No"    
 startRow = "start_row"    
 maxRows = "max_rows_output">    
</cfoutput>

<CFSET>
Defines a ColdFusion variable.

Syntax:

<cfset variable_name = expression>

<CFQUERY></CFQUERY>
Passes queries or SQL statements to a data source.

Syntax:
<cfquery      
 name = "query_name"    
 dataSource = "ds_name"    
 dbtype = "query"    
 username = "username"    
 password = "password"    
 maxRows = "number"    
 blockFactor = "blocksize"    
 timeout = "seconds"    
 cachedAfter = "date"      
 cachedWithin = "timespan"      
   
 Either of the following:    
   debug = "Yes" or "No"    
 or:    
   debug    
   
 SQL statement(s) >    
</cfquery>

<CFIF></CFIF>
Creates simple and compound conditional statements in CFML. Tests an expression, variable, function return value, or string. Used, optionally, with the cfelse and cfelseif tags.

Syntax:
<cfif expression>    
 HTML and CFML tags    
<cfelseif expression>    
 HTML and CFML tags      
<cfelse>    
 HTML and CFML tags    
</cfif>

LEN()
Determines the length of a string or binary object.

Syntax:
Len(string or binary object)

NOW()
Gets the current date and time of the computer running the ColdFusion server. The return value can be passed as a parameter to date functions.

Syntax:
Now()

DATEFORMAT()
Formats a date value. Supports dates in the U.S. date format.

Syntax:
DateFormat("date" [, "mask" ])

1138_reference

Tag specifications taken from ColdFusion MX Language Reference Guide,
Copyright Macromedia, Inc.

If you liked this article, share the love:
Print-Friendly Version Suggest an Article

Sponsored Links

Rate This Article

  • 1
    Poor
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
    Great

Comment on This Article

Have something to say?

Post A Comment

You need to be a member of the SitePoint Forums to comment on this post. Sign Up

Already a member? Post using your SitePoint Forums account: