asp怎样在下拉列表中固定的两个时间段之间查询sql数据库内的这个时间段内的数据

2025-03-24 22:28:36
推荐回答(1个)
回答1:

select * from user where time between #2014-10-1# and #2014-10-2#

换成你的2个下拉框
time1=request.form("start")
time2=request.form("end")
select * from user where time between #"&time1&"# and #"&time2&"#