SQL--> get from XXX where

[Guest_imported]

How can I get data from an access DB depending on what was selected in a SELECT tag on the page before.


I know you kan write somthing like

get * from XXX where = (a name of a form object ex. a hidden field)

but as the <select> tag doesn't have a name.... pleace help me...

Best R Erik

 

[NickBulka]

Why not just give the select tag a name?

 

[Guest_imported]

Because <select> & <option> tags doesn't take <name>...

 

[Guest_imported]

<select> tag does take name:

<select name=&quot;some_name&quot;>
<option value=&quot;some_value&quot;>Something
......................
<option value=&quot;someother_value&quot;>Something Else
</select>

And you can use values of the option elements in your script:

dim var

var = request.form(&quot;some_name&quot

 

[NickBulka]

the select tag DOES support the name attribute