Intro to CFML
This is an example of CFML query that produces a student list.
<cfquery name=“student_list” datasource=“student_db”>
SELECT studentID, studentName
The required attributes for <cfquery> are “name” and “datasource.” “Name” refers to an arbitrary name so that you can refer to this query in <cfoutput> and “datasource” refers to the unique datasource name specified in the ODBC Administrator tool in Microsoft Windows. For further informaiton on ODBC please see FAQ at (http://www.roth.net/odbc/odbcfaq.htm).