1 | <!--- Query to select customers ---> |
2 | <CFQUERY NAME="EmployeeList" DATASOURCE="CF 3.0 Examples"> |
3 | SELECT * FROM Employees |
4 | </CFQUERY> |
5 | <HTML> |
6 | <HEAD> <TITLE>Employee List</TITLE></HEAD> |
7 | <H2>Employee List</H2> |
8 | <!--- #FirstName#, #LastName#, #Phone# - Employees column names ---> |
9 | <CFOUTPUT QUERY="EmployeeList"> |
10 | <HR> #FirstName# #LastName# (Phone: #Phone#) <BR> |
11 | </CFOUTPUT> |
12 | </HTML> |