riqi1=request("riqi1")
riqi2=request("riqi2")
这行: sql="select * from moneyy where riqi between '"&riqi1&"' and '"&riqi2&"'" Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
...全文
11610打赏收藏
[求助]再asp中,怎么查询两个日期之间的记录呀?我写的有问题,大家帮我看看。。。。
riqi1=request("riqi1") riqi2=request("riqi2") 这行:sql="select * from moneyy where riqi between '"&riqi1&"' and '"&riqi2&"'"Set rs= Server.CreateObject("ADODB.Recordset") rs.open sql,conn,1,1
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
ODBC 驱动程序不支持所需的属性。
/google/caiwu1.asp,行18
riqi1=2004-12-20
riqi2=2004-12-21
riqi1=request("riqi1")
riqi2=request("riqi2")
sql="SELECT * FROM moneyy WHERE datee BETWEEN #"&riqi1&"# AND #"&riqi2&"#"
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1 //18行
if rs.eof and rs.bof then
riqi1=request("riqi1")
riqi2=request("riqi2")
if isdate(riqi1) and isdate(riqi2) then
sql="select * from moneyy where riqi > #"&riqi1&"# and riqi< #"&riqi2&"#"
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
end if
riqi1=request("riqi1")
riqi2=request("riqi2")
if isdate(riqi1) and isdate(riqi2) then
sql="select * from moneyy where riqi between '"&riqi1&"' and '"&riqi2&"'"
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
end if