Basic HTML version of Foils prepared May 3 1998

Foil 52 Dynamic HTML Forms - III

From Java Blend and Cold Fusion High Level Database Interfaces CPS616 Web Technologies -- Spring 98. by Chao Wei Ou
Single quotes must be added to the value attributes of the checkboxes.
<INPUT TYPE="checkbox" NAME="SelectedOrgs" VALUE="'Mobil Corp.'">Mobil Corporation<BR>
<INPUT TYPE="checkbox" NAME="SelectedOrgs" VALUE="'Bank of Boston'"> BankBoston<BR>
Cfm includes:
SELECT * FROM Organizations WHERE OrganizationName IN
(#PreserveSingleQuotes(SelectedOrgs)#)
The statement sent to the database would be:
SELECT * FROM Organizations WHERE OrganizationName IN
('Mobil Corp.', 'BankBoston')

© 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