MACROMEDIA COLFUSION MX 7-GETTING STARTED BUILDING COLDFUSION..., Getting Started

Page: 37 / 152

Using SQL with ColdFusion 37
Writing SQL and CFML statements to interact with a data source
After ColdFusion makes a connection to the data source, you can interact with that database by
using SQL and ColdFusion.
To interact with an established data source, you must include SQL statements in your CFML
statements; for example:
<cfquery name="queryname" datasource="namedbfile">
SELECT FirstName, LastName, DepartmentID
From Employee
</cfquery>
In this example, the first attribute of the
cfquery
tag is the name of the query. The second
attribute of the
cfquery
tag defines the name of the data source. The
SELECT
statement defines
the fields (columns) to be retrieved from a table named Employee.
CFML tags that interact with a database
The following table lists the CFML tags that you can use to interact with a database:
Part II of this manual introduces these tags when you use them to interact with the sample
database. For more information about interacting with a database, see
ColdFusion MX Developer’s
Guide or CFML Reference.
Tag Description
cfquery To retrieve (query) information in a database.
cfinsert To add records to a database.
cfupdate To update information in a database.