Question

asp查询两个时间段之间的表数据

access数据库；表user；姓名bname;票数zhit；时间infotime （yyyy-mm-dd格式）；
select.asp页
两个输入框time1,time2，分别输入要查询的起始时间和结束时间，点击提交表单后，查询在输入的这两个时间内，票数whit最大的姓名bname。并返回数据。
求教应该怎么做。感谢

Answer 1

用between来做

追问

sql="select * from user where infotime between #2012-1-1# and #2012-12-31#"

用between可以，但是，我想把上句中的2012-1-1换成time1。2012-12-31换成time2
time1=request.form("start")
time2=request.form("end")
这样就不行了...

追答

sql="select * from user where infotime between #"&time1&"# and #"&time2&"#"

Answer 2

http://zhidao.baidu.com/question/446845293.html?oldq=1

追问

sql="select * from user where infotime between #2012-1-1# and #2012-12-31#"
用between可以，但是，我想把上句中的2012-1-1换成time1。2012-12-31换成time2
time1=request.form("start")
time2=request.form("end")
这样就不行了...

Answer 3

sql="select * from user where infotime between #"+time1+"# and #"+time2+"#"