billysaw
asked on
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!
Billy
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!
Billy
ASKER
JUST TO MAKE SURE:
Is the "dropdown_name" the name of the FORM or the name of the SELECT?
Is the "dropdown_name" the name of the FORM or the name of the SELECT?
name of the SELECT box
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
it may conflict with another form element
try to check the value
response.write (Request("dropdown_name"))