终于搞定了,原来是软件环境问题,我以前是用的windows2003+SQL2000,没有办法,我今天换成Windows2000+SQL2000,就可以了。谢谢lq7350684版主的技术支持。
<%
set rs2=server.createobject("adodb.recordset")
sql2="select * from info_testitem order by projectCustomer"
rs2.open sql2,conn,1,1
do while not rs2.eof %>
<option value="<%=rs2("ProjectCustomer")%>"><%=rs2("ProjectCustomer")%></option>
<% rs2.movenext
loop
rs2.close %>
<%
set rs2=server.createobject("adodb.recordset")
sql2="select * from info_testitem order by projectCustomer"
rs2.open sql2,conn,1,1
do while not rs2.eof %>
<option value="<%=rs2("ProjectCustomer")%>"><%=rs2("ProjectCustomer")%></option>
<% rs2.movenext
loop
rs2.close %>