We have a classic ASP page that runs some SQL on a database and returns a small recordset when the page is loaded.
I have updated the page to include a combo box with vaules that I would like a user to select from, then click a button to execute a stored procedure and refresh the data/result set.
So far I cannot get the ASP to rerun the query, although I can get the reurned result.
Currently, the combo lists 12 months from NOW. eg, you will see a list with June 2010
Selecting May will return a value of 5 that would be passed to stored proc and refresh the data and page.
I could easily handle the list index ref rather than the month number, what ever is easier. Since I dont know much about ASP, I need someone to just correct the code and return the page. I will work with the coder to test promptyly.
See attached file