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


1 Single quotes must be added to the value attributes of the checkboxes.
2 <INPUT TYPE="checkbox" NAME="SelectedOrgs" VALUE="'Mobil Corp.'">Mobil Corporation<BR>
3 <INPUT TYPE="checkbox" NAME="SelectedOrgs" VALUE="'Bank of Boston'"> BankBoston<BR>
4
5 Cfm includes:
6 SELECT * FROM Organizations WHERE OrganizationName IN
7 (#PreserveSingleQuotes(SelectedOrgs)#)
8
9 The statement sent to the database would be:
10 SELECT * FROM Organizations WHERE OrganizationName IN
11 ('Mobil Corp.', 'BankBoston')

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