<!--- Query to select customers ---> |
<CFQUERY NAME="EmployeeList" DATASOURCE="CF 3.0 Examples"> |
SELECT * FROM Employees |
</CFQUERY> |
<HTML> |
<HEAD> <TITLE>Employee List</TITLE></HEAD> |
<H2>Employee List</H2> |
<!--- #FirstName#, #LastName#, #Phone# - Employees column names ---> |
<CFOUTPUT QUERY="EmployeeList"> |
<HR> #FirstName# #LastName# (Phone: #Phone#) <BR> |
</CFOUTPUT> |
</HTML> |