| 1 |
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.">
|
| 2 |
In other CFM page includes the following SQL statement
-
SELECT * FROM Organizations
-
WHERE OrganizationName IN (#PreserveSingleQuotes(SelectedEmp)#)
|
| 3 |
Actual statement to be sent to database:
-
SELECT * FROM Organizations
-
WHERE OrganizationName IN (`Staff','Student')
|
