| 1 |
In the HTML form, select one or more companies to get information on:
|
| 2 |
<INPUT TYPE="checkbox" NAME="SelectedOrgs" VALUE=5>
|
| 3 |
Mobil Corporation<BR>
|
| 4 |
<INPUT TYPE="checkbox" NAME="SelectedOrgs" VALUE=19>
|
| 5 |
Shapeware, Inc.<BR>
|
| 6 |
<INPUT TYPE="checkbox" NAME="SelectedOrgs" VALUE=13>
|
| 7 |
BankBoston<BR>
|
| 8 |
<INPUT TYPE="hidden" NAME="SelectedOrgs_required"
|
| 9 |
VALUE="You must select at least one organization.">
|
| 10 |
|
| 11 |
The cmf program that processes the form includes:
|
| 12 |
SELECT * FROM Organizations
|
| 13 |
WHERE Organization_ID IN ( #SelectedOrgs# )
|
| 14 |
|
| 15 |
If the users selects Shapeware and BankBoston, the statement sent to the database would be:
|
| 16 |
SELECT * FROM Organizations
|
| 17 |
WHERE Organization_ID IN ( 19, 13 )
|
