Basic HTML version of Foils prepared May 3 1998

Foil 23 Creating a Page to Select Data

From Java Blend and Cold Fusion High Level Database Interfaces CPS616 Web Technologies -- Spring 98. by Chao Wei Ou
1 Syntax
2
3 <CFQUERY NAME="query_name"
4 DATASOURCE="ds_name"
5 USERNAME="username"
6 PASSWORD="password"
7 MAXROWS="number"
8 TIMEOUT="milliseconds"
9 DEBUG="yes/no">
10
11 SQL statements
12
13 </CFQUERY>
14 Example: (EmployeeSearch.cfm)
15
16 <CFQUERY NAME="EmployeeList" DATASOURCE=
17 "CF 3.0 Examples">
18
19 SELECT * FROM Employees
20
21 </CFQUERY>
22 CFML query tag (in a .cfm file on the server):
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