請問我這樣連接數据庫,怎么在瀏覽器上沒有顯示我要地那張表(cs)的字段 cs_prop?是不是語句有錯,請幫忙改一下,謝謝!

<%
set conn=server.createobject("adodb.connection")
conn.open ("driver={SQL Server};server=192.168.0.109;uid=sa;pwd=1a2b3c;database=torus_dbf")

sql="select distinct cs_prop from cs"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
%>

<%
select_tmp = ""
do while not rs.eof
%>
<option value="<%=rs("cs_prop")%>"><%=rs("cs_prop")%></option>
<%
rs.movenext
loop
set rs=nothing
set conn=nothing
%>

<%
dim conn
set conn=server.createobject("ADODB.connection")
conn.open "provider=sqloledb;server=(local);database=torus_dbf;uid=sa;pwd=1a2b3c;"

set rs=Server.CreateObject("ADODB.Recordset")
rs.open "select distinct(cs_prop) from cs",conn,1,1
set cs_prop=rs("cs_prop")
do while not rs.eof
%>
<option value="<%=cs_prop%>"><%=cs_prop%></option>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>

进行唯一查询~~~