UC知道请问错误在哪呀?ASP
来源：百度知道 编辑：UC知道 时间：2024/06/08 15:50:15
rst.open "select top 8 * from daohang where daishen=1, datediff(d,shijian,getdate()) = 1 order by laici desc",conn,3,2
我想查询前一天的记录怎么不行呀!!请问错误在哪呀?
rst.open "select top 8 * from daohang where (datediff(d,[shijian],now())=0) order by laici desc",conn,3,2
<font face="宋体" size=2>[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 2。</font>
我想查询前一天的记录怎么不行呀!!请问错误在哪呀?
rst.open "select top 8 * from daohang where (datediff(d,[shijian],now())=0) order by laici desc",conn,3,2
<font face="宋体" size=2>[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 2。</font>
rst.open "select top 8 * from daohang where daishen=1 and datediff(d,shijian,getdate()) = 1 order by laici desc",conn,1,1
查询条件不对，格式不正确！
试试这个
rst.open "select top 8 * from daohang where daishen=1 and datediff(d,shijian,getdate()) = 1 order by laici desc",conn,3,2
逗号改and