Dynamically populated option box question

[Tread42]

Is this possible to do? In another page I've captured a particular customer type say they have cust=1 or cust=2. What I want to do is that if cust=2 then they can't see two values from a drop-down list box. So cust 1 see values "A,B,C,D" in the drop-down and cust 2 sees "A,B". Does anyone know how to do this with an option/list box?

Thanks Regards,
Tread42

 

[JohnBates]

Hi Tread42,

Yes, definitely doable.

Here is an example I did for an ASP page.

I only wanted to populate the year-box with years that actually had data in the table. Why show 2000 or 2003 in the select box if there is no data in the table for those years... right? What you want to do is similar...

Good luck, john

It is written in VBscript:

<%
'Build the dropdown box entries
'Retrieve all unique year values in the LoadHist table so we can populate the YR dropdown box

sql = &quot;SELECT DISTINCT year(DateClosed) As YearClosed FROM LoadHist ORDER BY YearClosed&quot;


set rs = createobject(&quot;adodb.recordset&quot

rs.open sql,conn, adOpenStatic, adLockReadOnly, adCmdText


'Add entries to the selection box for each year we have accumulated Load history for
%>


<SELECT NAME=&quot;YR&quot; size=&quot;1&quot; onChange=&quot;Loads.submit()&quot;>
<option>Select a year</option>

<%
Do While NOT rs.eof
%>


<option value=&quot;<%=rs.Fields(&quot;YearClosed&quot%>&quot;>
<%=rs.Fields(&quot;YearClosed&quot%>
</option>

<%

rs.MoveNext()
Loop

'...end of section that builds the dropdown box
%>
</SELECT>

 

[dolphyn]

Hi Tread42 and JohnBates

I just want to let you know that this is also doable without ASP. ASP would be preferable to populate large lists, as JohnBates has shown, but for small lists you can do it with JavaScript.

This site explains it fairly well:

http://www.beginnersjavascript.co.uk/practical/dynamic_dropdowns.html