How do I

[zishan619]

Hi:
I am using Interdev for my asp page. I am very new at this. So please help. I have a SQL statement that connects back to my SQL server database. In the SQL statement there is a WHERE statement that runs off the drop down box I have on the page. How do I place in that dropdown value into that statement everytime an analyst picks it. Once an analyst selects a value from the dropdown it produces a report from it.
Thanks
Z

 

[cbokowski]

you can either have client side code to submit or a submit button.

On the server something like this will work.

strSql = "select * from [mytable] where field= '" & request("myDropdown&quot &"'"