ansaurus

Question

How to display data from stored procedure in a drop down in Classic ASP ?

Answer 1

+1 A:

Gaby 2010-07-26 13:35:14

@RMN, updated answer.. (*you never write the options in the page*)

Gaby 2010-07-26 13:53:33

Thanks Gaby. Seems i am getting closer to it. I do not want to add the fields as static value. "Location" is the Value i am getting from Stored proc which i need in drop down.I added response.write(SiteLocationList) just above rsSiteList.MoveNext and it showd me 3 entries in drop down, rest all in a line outside dropdown.Also i want the value selected in <%=rsReqDetails("AppReqSiteID")%> as the default selection in the drop down.

RMN 2010-07-26 14:10:13

@RMN, do not print the SiteLocationList from inside the loop, because you are adding the options to it, so each time you print it, it will print all the options again increased by one.. Also, what is the `<%=rsReqDetails("AppReqSiteID")%>` ? another recordset ? and that value should be checked with what ? does your `rsSiteList` recordset have id values as well somewhere ?

Gaby 2010-07-26 14:16:21

Yes, it is another recordset and no, rsSiteList has no Id, it has only values("Location"). Now the scenario is something like: For a Project-ID '122' I have details in recordset "rsReqDetails". The "AppReqSiteID" for Project 122 is "Two". I want the dropdown to show "One","Two","Three" ... and by default "Two" should be selected. This dropdown is what right now we are trying to fix. Also if i change the selection to "One", it should save changes in database on click of Save button.

RMN 2010-07-26 14:40:58

Ok, Now i can see the Drop down and the values in it, but how do I display the selected value(that is value in: <%=rsReqDetails("AppReqSiteID")%> ) as default selection in this dropdown.

RMN 2010-07-27 03:32:28

@Nimesh, are you sure that the `rsReqDetails("AppReqSiteID")` is equal to one of the `rsSiteList("LOCATION")` ? because the example above should select it if it finds it ..

Gaby 2010-07-27 10:43:18

Yes, for all the entries it shows the first location from dropdown.

RMN 2010-07-27 15:11:53

And not Nimesh.. :) rmn .. :)

RMN 2010-07-27 15:12:34

Gaby, i am still not able to see the required selection. Only first option from the dropdown list is default selected.

RMN 2010-07-29 07:44:23

@RMN, can you please add cahnge the `<select id="SiteLocationList" NAME="SiteLocationList">` to `<select id="SiteLocationList" NAME="SiteLocationList" value="<%=selectedValue%>">` and post here the rendered result (*view source and show us what is there..*)

Gaby 2010-07-29 08:47:09

Ok, that is a silly mistake of mine :( i referenced Location in stored proc where as it should have been Site. Thanks for the last comment, it helped me find this out.Thanks a lot for all your help in solving this issue.

RMN 2010-07-29 15:08:46

Answer 2

A:

You almost got it, you're missing the "select" tag:

    strSQL = "SP_GET_SiteLocation"  
Set rsSiteList = RunSQLQuery(strSQL)  

'show the list  
If Not rsSiteList.EOF Then  %>
<select><%Do While NOT rs.EOF SiteLocationList= SiteLocationList & "<option value="">" & rs("LOCATION") & "</option>"  
rs.MoveNext %>
</select>

Andrea 2010-07-26 13:38:27

Yes, this displays the drop-down, but empty dropdown :(

RMN 2010-07-26 13:48:19

ansaurus

tags:

views:

answers:

How to display data from stored procedure in a drop down in Classic ASP ?

related questions