楼主这个不用子前台作判断,在后台处理就可以了
sql = "select * from table where 1=1"
if title <> "" then
sql = sql & " and title like'%"&title&"%'"
end if
if time1 <> "" then
sql = sql & " and datediff(....)"
end if
if time2 <> "" then
sql = sql & " and datediff(....)"
end if