警告:ODBC_EXEC():SQL错误:[Microsoft] [ODBC Microsoft Access驱动程序]

Question

im使用 PHP > ODBC

获得错误

警告：ODBC_EXEC（）：SQL错误：[Microsoft] [ODBC Microsoft Access 驱动程序]参数太少。预期1.，SQL状态07001 IN sqlexectirect

$sql='SELECT 
        CHECKINOUT.CHECKTIME,
        USERINFO.Badgenumber,
        USERINFO.Name
    FROM
        CHECKINOUT
    RIGHT JOIN
        USERINFO ON CHECKINOUT.USERID = USERINFO.USERID
    WHERE
        c.CHECKTIME >= #'.$dateToday.' 00:00:00# AND c.CHECKTIME <= #'.$dateToday.' 23:59:59#
    ORDER BY
        CHECKINOUT.CHECKTIME DESC
    ';

Answer 1

通过添加{ts}

修复了此代码

SELECT 
        CHECKINOUT.CHECKTIME,
        USERINFO.Badgenumber,
        USERINFO.Name
    FROM
        CHECKINOUT
    RIGHT JOIN
        USERINFO ON CHECKINOUT.USERID = USERINFO.USERID
    WHERE
        CHECKINOUT.CHECKTIME BETWEEN  {ts '".$reqDTS."'} AND {ts '".$reqDTE."'}
    ORDER BY
        CHECKINOUT.CHECKTIME DESC