the incredible disappearing dynamic dropdown -
06-25-2004
, 04:55 PM
I can't figure out if this is a CSS problem, ASP problem or ???
Our client has moved their hosting from a linux/mysql environment to a
rackspace Win2000/mysql environment and they are noticing some weirdness
after the move. The most weird is the fact that the values of their
dropdown menus have acquired the same font color as the background of the
dropdown itself rendering them useless.
I've checked the CSS, taken all CSS off the form element, taken everything
but the dropdown off the page including the CSS tags and all color tags and
I get the same result.
If you select one of the "ghost" items in the dropdown menu they work but I
just can't see what I'm clicking on..
Recordset code looks like this
<%
Dim rsMake
Dim rsMake_numRows
Set rsMake = Server.CreateObject("ADODB.Recordset")
rsMake.ActiveConnection = MM_our_STRING
rsMake.Source = "SELECT DISTINCT make FROM cartable WHERE location = 'SGF'
ORDER BY 'make' ASC"
rsMake.CursorType = 0
rsMake.CursorLocation = 2
rsMake.LockType = 1
rsMake.Open()
rsMake_numRows = 0
%>
The dropdown code looks like this;
<form name="form1" method="get" action="inventory_sgf_make.asp">
<div align="center">
<select name="make" id="make" onChange=form1.submit()>
<option value="">Search by Make</option>
<%
While (NOT rsMake.EOF)
%>
<option
value="<%=(rsMake.Fields.Item("make").Value)%>"><% =(rsMake.Fields.Item("make
").Value)%></option>
<%
rsMake.MoveNext()
Wend
If (rsMake.CursorType > 0) Then
rsMake.MoveFirst
Else
rsMake.Requery
End If
%>
</select>
</div>
</form> |