<span style="width:60;border:1px solid black;overflow:hidden"><SELECT id="selFactory" size="1" name="selFactory">
<option value ="">--全部--</option>
<%
'搜索制造厂家形成下拉列表
' 制造厂家记录集
dim rsFactory
strSql = "exec sp_SelFactory "
set rsFactory = conn.execute(strSql)
while not rsFactory.eof
if len(rsFactory("strFactory"))>0 then '过滤掉为空的制造厂家
%>
<option value=<%=rsFactory("strFactory")%>
<%=rsFactory("strFactory")%>
</option>
<%
end if
rsFactory.movenext
wend
rsFactory.close
set rsFactory = nothing
%>
</SELECT></span>
看这样能不能满足你的要求