Basic HTML version of Foils prepared May 3 1998

Foil 31 A More Complicated CF Page (employeesearch.cfm)

From Java Blend and Cold Fusion High Level Database Interfaces CPS616 Web Technologies -- Spring 98. by Chao Wei Ou
1 <CFQUERY NAME="EmployeeList" DATASOURCE="CF 3.0 Examples">
2 SELECT * FROM Employees WHERE LastName LIKE '%#LastName#%'
3 AND Department = '#Department#'
4 </CFQUERY>
5 <HTML>
6 <HEAD><TITLE>Employee Search Results</TITLE></HEAD>
7 <H2>Organization Search Results</h2>
8 <CFOUTPUT>
9 <P>The Search for #Form.LastName# in the #Form.Department# returned these results:</P>
10 </CFOUTPUT>
11 <CFOUTPUT QUERY="EmployeeList">
12 <HR>#FirstName# #LastName# (Phone: #Phone#) <BR>
13 </CFOUTPUT>
14 </HTML>
in Table To:

© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Sat Nov 28 1998