where year(<field>)=1999 and month(<field>)=1 不行,提示“参数不足”,1999和1要在程序运行中输入。
你数据库中的字段明明是mm/dd/yy,那你只是输入年月,那当然参数不足
dim rs,conn dim year,month dim dt1,dt2 conn=createobject('adodb.connection') rs=createobject('adodb.recordset') conn.open "..."year=1999 month=1 dt1=""& year &"-" & month &"-1 00:00:00.000" dt2=""& year &"-" & month &"-31 59:59:59.999" sql="select * from tbl where dt>='"& dt1 &"' and dt<='" & dt2 & "'" rs.open(sql,conn)
dim rs,conn dim year,month dim dt1,dt2 conn=createobject('adodb.connection') rs=createobject('adodb.recordset') conn.open "..."year=1999 month=1 dt1=""& year &"-" & month &"-1 00:00:00.000" dt2=""& year &"-" & month &"-31 59:59:59.999" sql="select * from tbl where dt>='"& dt1 &"' and dt<='" & dt2 & "'" rs.open(sql,conn)
dim rs,conn dim year,month dim dt1,dt2 conn=createobject('adodb.connection') rs=createobject('adodb.recordset') conn.open "..."year=1999 month=1 dt1=""& year &"-" & month &"-1 00:00:00.000" dt2=""& year &"-" & month &"-31 59:59:59.999" sql="select * from tbl where dt>='"& dt1 &"' and dt<='" & dt2 & "'" rs.open(sql,conn)
dim year,month
dim dt1,dt2
conn=createobject('adodb.connection')
rs=createobject('adodb.recordset')
conn.open "..."year=1999
month=1
dt1=""& year &"-" & month &"-1 00:00:00.000"
dt2=""& year &"-" & month &"-31 59:59:59.999"
sql="select * from tbl where dt>='"& dt1 &"' and dt<='" & dt2 & "'"
rs.open(sql,conn)
dim year,month
dim dt1,dt2
conn=createobject('adodb.connection')
rs=createobject('adodb.recordset')
conn.open "..."year=1999
month=1
dt1=""& year &"-" & month &"-1 00:00:00.000"
dt2=""& year &"-" & month &"-31 59:59:59.999"
sql="select * from tbl where dt>='"& dt1 &"' and dt<='" & dt2 & "'"
rs.open(sql,conn)
dim year,month
dim dt1,dt2
conn=createobject('adodb.connection')
rs=createobject('adodb.recordset')
conn.open "..."year=1999
month=1
dt1=""& year &"-" & month &"-1 00:00:00.000"
dt2=""& year &"-" & month &"-31 59:59:59.999"
sql="select * from tbl where dt>='"& dt1 &"' and dt<='" & dt2 & "'"
rs.open(sql,conn)