Advanced SQL
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')