String manipulation to create criterion string for a recordset

Hi,

As for your 1st Q, to create a multi select option list you have to use

<SELECT id=selSomeName name=selSomeName multiple>
<OPTION></OPTION>
<OPTION></OPTION>
<OPTION></OPTION>
</SELECT>

You'll receive these values as part of the POST string separated, if I remember correctly by ?. Just print the row string once and you'll see.

The SQL you have to use will look some thing like :

SELECT * FROM tblMyTable WHERE fldMyField = <OPTION1'S value> OR fldMyField = <OPTION2'S value>;

Erez