I am trying to use the following code shown below

The problem is that it works fine in IE & Opera, but fails in any Mozilla product


<%
  If Not objRS.EOF Then
  objRS.MoveFirst
%>
  <form method="get" action= "<%= strURL %>">
  <select name="search">
  <option>Select Class</option>
<%
  Do While Not objRS.EOF
%>
  <option value><%= objRS.Fields("lclas") %></option>
<%
objRS.MoveNext
Loop
%>
</select>
<%
end if
objRS.Close
Set objRS = Nothing
objDC.Close
Set objDC = Nothing
strsearch = trim(Request.QueryString("search"))
response.write "strsearch passed is.. "
response.write strsearch

When in IE the response write shown for example is

"strsearch passed is.. A-2"

but in Mozilla all I get is

"strsearch passed is.."

in consequence my sql statement fails because there is nothing to search on ???

I just cannot see why something this basic is falling over
so any help here would be much appreaciated

Thanks

Topshed

Please modify the following line:
 <option value><%= objRS.Fields("lclas") %></option>
as
 <option value= "<%=objRS.Fields("lclas")%>"><%=objRS.Fields("lcla s")%></option>

Om Prakash

Thank you SO much an instant fix..

Could you please explain Why it only failed on Mozilla ?

Regards Topshed

It failed in Mozilla because <option value> is not the valid syntax. IE ignores the error and returns the content.

But for Mozilla, this is invalid syntax, so no values are returned.

Following are valid syntax:
 <option>TEST</option>
 <option value = "1">TEST</option> (If text/value is different)

Below code can also be written as:
 <option><%= objRS.Fields("lclas") %></option>
instead of
 <option value= "<%=objRS.Fields("lclas")%>"><%=objRS.Fields("lcla s")%></option>



Om Prakash