Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect

Question

Im getting an error using PHP > ODBC

Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect

$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

Fixed this code by adding {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