Getting Started
5 snippetsYour first steps with ColdFusion
Hello World
<cfoutput>Hello, World!</cfoutput>Variables
<cfset myVar = "Hello">
<cfset myNum = 42>Comments
<!--- This is a CFML comment --->Output Variable
<cfoutput>#myVar#</cfoutput>Include File
<cfinclude template="header.cfm">Variables & Scopes
6 snippetsVariable declaration and scopes
Local Variable
<cfset local.myVar = "value">Request Scope
<cfset request.userId = 123>Session Variable
<cfset session.userName = "John">Application Variable
<cfset application.siteName = "MySite">URL Parameters
<cfset userId = url.id>Form Variables
<cfset userName = form.name>Control Flow
6 snippetsConditional logic and loops
If/Else
<cfif age GT 18>
Adult
<cfelseif age EQ 18>
Just turned 18
<cfelse>
Minor
</cfif>Switch
<cfswitch expression="#status#">
<cfcase value="active">Active</cfcase>
<cfcase value="pending">Pending</cfcase>
<cfdefaultcase>Unknown</cfdefaultcase>
</cfswitch>For Loop
<cfloop from="1" to="10" index="i">
<cfoutput>#i#</cfoutput>
</cfloop>While Loop
<cfloop condition="i LT 10">
<cfset i = i + 1>
</cfloop>Loop Array
<cfloop array="#myArray#" index="item">
<cfoutput>#item#</cfoutput>
</cfloop>Loop Query
<cfloop query="myQuery">
<cfoutput>#name# - #email#</cfoutput>
</cfloop>Tired of looking up syntax?
DocuWriter.ai generates documentation and explains code using AI.
Functions
3 snippetsCreating and using functions
Define Function
<cffunction name="greet" returntype="string">
<cfargument name="name" type="string" required="true">
<cfreturn "Hello, #arguments.name#!">
</cffunction>Call Function
<cfset message = greet("World")>Script Syntax
<cfscript>
function add(a, b) {
return a + b;
}
</cfscript>Database Operations
4 snippetsWorking with databases
Query
<cfquery name="users" datasource="myDB">
SELECT * FROM users
WHERE active = 1
</cfquery>Parameterized Query
<cfquery name="user" datasource="myDB">
SELECT * FROM users
WHERE id = <cfqueryparam value="#userId#" cfsqltype="cf_sql_integer">
</cfquery>Insert
<cfquery datasource="myDB">
INSERT INTO users (name, email)
VALUES (
<cfqueryparam value="#form.name#" cfsqltype="cf_sql_varchar">,
<cfqueryparam value="#form.email#" cfsqltype="cf_sql_varchar">
)
</cfquery>Query of Queries
<cfquery name="filtered" dbtype="query">
SELECT * FROM users
WHERE age > 21
</cfquery>Components (CFCs)
3 snippetsObject-oriented ColdFusion
Create Component
<!--- User.cfc --->
<cfcomponent>
<cfproperty name="name" type="string">
<cffunction name="init" returntype="User">
<cfargument name="name" type="string">
<cfset this.name = arguments.name>
<cfreturn this>
</cffunction>
</cfcomponent>Instantiate
<cfset user = createObject("component", "User").init("John")>New Syntax
<cfset user = new User("John")>