Basic HTML version of Foils prepared May 3 1998

Foil 29 Using Dynamic Parameters in SQL Statements

From Java Blend and Cold Fusion High Level Database Interfaces CPS616 Web Technologies -- Spring 98. by Chao Wei Ou
1 SQL statement with dynamic parameters:
2
3 SELECT * FROM Employees
4 WHERE LastName = '#Form.LastName#'
5
6 If the user entered "Rucker" for LastName, the SQL statement sent to the database would be:
7
8 SELECT * FROM Employees
9 WHERE LastName = 'Rucker'
10 Syntax for cfm file to refer to parameters from the form:
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