d1=request("d1")
d2=request("d1")
sql="select * from client where date1 between '"&d1&"' and '"&d2&"'
and date2 between '"&d1&"' and '"&d2&"'"
d2=request("d1")
sql="select * from client where date1 between '"&d1&"' and '"&d2&"'
and date2 between '"&d1&"' and '"&d2&"'"
d1=request("d1")
d2=request("d2")
sql="select * from client where date1= '"&d1&"' and date2= '"&d2&"'"
d2=request("d2")
sql="select * from client where date1>= '"&d1&"' and date2<= '"&d2&"'"
注意我的开始和结束时间是在两个字段下,不是在一个字段下。所以以上方法不行??what's meaning?