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