为什么这段代码不能检测相同日期禁止录入？请看看有什么不妥！
数据库 weather
字段 tq_date 格式为: "短日期 " 2007-8-14
我想禁止录入相同日期看看下面代码为什么不能判断？
<%
set rs = server.CreateObject ( "adodb.recordset ")
sql = "select * from [weather] where tq_date= "&request( "tq_date ")
rs.Open sql,conn,1,1
if rs.bof=false and rs.eof=false then
response.write " <script language=javascript> alert( '温馨提示：日期重复，禁止录入！ ');history.go(-1); </script> "
rs.close
else
set rs = server.CreateObject ( "adodb.recordset ")
sql = "select * from weather "
rs.Open sql,conn,1,3
rs.AddNew
rs( "tq_date ") = Request( "tq_date ")
rs( "tqxx1 ") = Request( "tqxx1 ")
rs( "tqxx_img ") = Request( "tqxx_img ")
rs( "qiwen1 ") = Request( "qiwen1 ")
rs( "qiwen2 ") = Request( "qiwen2 ")
rs( "windy ") = Request( "windy ")
rs.Update
rs.Close
set rs=nothing
end if
%>
<script language=javascript>
alert( "录入成功 " );
location.href = "login.asp "
</script>
<%end if%>
<%end sub%>
[解决办法]
你用的数据库是access还是sqlserver？
access：
sql = "select * from [weather] where tq_date=# " & request( "tq_date ") & "# "
sqlserver:
sql = "select * from [weather] where tq_date= ' "&request( "tq_date ") & " ' "
试一下看
