Basic HTML version of Foils prepared 26 Jan 98

Foil 17 Advanced SQL

From Web-Linked Database Cold Fusion Tutorial ARL Database Tutorial -- February 98. by Chao Wei Ou


Select one or more companies to get more information on:
  • <SELECT Name="SelectEmp" MULTIPLE>
  • <OPTION VALUE="'Staff'">Staff
  • <OPTION VALUE="'Student'">Student
  • </SELECT>
  • <INPUT type="hidden" NAME="SelectedEmp_required"
  • VALUE="You must select at least one category.">
In other CFM page includes the following SQL statement
  • SELECT * FROM Organizations
  • WHERE OrganizationName IN (#PreserveSingleQuotes(SelectedEmp)#)
Actual statement to be sent to database:
  • SELECT * FROM Organizations
  • WHERE OrganizationName IN (`Staff','Student')



© 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 Mon Jan 26 1998