1 | Single quotes must be added to the value attributes of the checkboxes. |
2 | <INPUT TYPE="checkbox" NAME="SelectedOrgs" VALUE="'Mobil Corp.'">Mobil Corporation<BR> |
3 | <INPUT TYPE="checkbox" NAME="SelectedOrgs" VALUE="'Bank of Boston'"> BankBoston<BR> |
4 | |
5 | Cfm includes: |
6 | SELECT * FROM Organizations WHERE OrganizationName IN |
7 | (#PreserveSingleQuotes(SelectedOrgs)#) |
8 | |
9 | The statement sent to the database would be: |
10 | SELECT * FROM Organizations WHERE OrganizationName IN |
11 | ('Mobil Corp.', 'BankBoston') |