title: How to display data from stored procedure in a drop down in Classic ASP?
body: <p>This is related to Classic ASP code. 
  A page fetches data for a particular ProjectCode.</p>
  
  <p>There is a general text field which shows the Site-Location for selected Project-Code. I want to change it to drop down, so that a user can change the Site-Location from options available (fetched from DB) and then save it. Also, on page load the Site-Location of Project-Code for that particular entry should be selected.</p>
  
  <p>I have added following code to my Page, but it doesn't work(definately I am new to classic ASP). </p>
  
  <pre><code>    strSQL = "SP_GET_SiteLocation"
      Set rsSiteList = RunSQLQuery(strSQL)
  
      'show the list
      If Not rsSiteList.EOF Then
      Do While NOT rs.EOF
      SiteLocationList= SiteLocationList &amp; "&lt;option value=""&gt;" &amp; rs("LOCATION") &amp; "&lt;/option&gt;"
      rs.MoveNext 
  </code></pre>
  
  <p>Also, on click of save button, i have to send the selected drop down value to update query.</p>