ASP: Retrieving database data using drop-down menu
I am trying to retrieve data from an ACCESS database in ASP code such as
sql="SELECT * FROM tablewithdata WHERE mydata =' & request("myformdata") & ' "
This is working if MYFORMDATA is the name element of a INPUT textbox-stand alone- on my form but it is not working if this is the name of the SELECT element of a drop-down menu with a number of options.
What am I missing??
Its a simple question but I will not be mean with the points!