UC知道asp日期段的查询问题？急
来源：百度知道 编辑：UC知道 时间：2024/05/16 14:50:10
我通过2个文本框分别传递最小日期和最大日期到查询结果页中进行处理，在文本框中有日期时可以查询到结果数据。但是，如果文本框中什么都填直接点查询按钮就提示我“日期的语法错误 在查询表达式 'date between ## and ## and pass='是'and qy like '%江汉区%'' 中”
我的查询结果页代码是这样的
<%
dim strSql,rs,i,PageNo,date1,date2
date1=request("search_textdate1")
date2=request("search_textdate2")
if request("search_bh")="" and request("search_qy")="" and request("search_username")="" and request("search_Identity")="" and request("search_Spouse_name")="" and request("search_Spouse_Identity")=""and request("search_Comments_year")="" and request("search_Comments_month")="" and request("search_Comments_day")="" and request("search_date")="" and request("search_textdate1")="" and request("search_textdate2")=
我的查询结果页代码是这样的
<%
dim strSql,rs,i,PageNo,date1,date2
date1=request("search_textdate1")
date2=request("search_textdate2")
if request("search_bh")="" and request("search_qy")="" and request("search_username")="" and request("search_Identity")="" and request("search_Spouse_name")="" and request("search_Spouse_Identity")=""and request("search_Comments_year")="" and request("search_Comments_month")="" and request("search_Comments_day")="" and request("search_date")="" and request("search_textdate1")="" and request("search_textdate2")=
dim strSql,rs,i,PageNo,date1,date2
date1=request("search_textdate1")
date2=request("search_textdate2")
strSql="select * from [house_jianghan] where pass='是' "
if date1 <> "" then strSql = strSql&" and DateDiff('d',"&date1&",最小时间) => 0 "
if date2 <> "" then strSql = strSql&" and DateDiff('d',"&date2&",最大时间) => 0 "
if request("search_bh")="" and request("search_qy")="" and request("search_username")="" and request("search_Identity")="" and request("search_Spouse_name")="" and request("search_Spouse_Identity")=""and request("search_Comments_year")="" and request("search_Comments_month")="" and request("search_Comments_day")="" and request(&q