How to correctly prepare and execute an odbc connection

Asked Jul 19 '16 at 15:33

Active Jul 19 '16 at 18:11

Viewed 60 times

I am getting the following error when trying to prepare and execute a statement:

Invalid character value for cast specification, SQL state 22005 in SQLExecute

Is there something I can do differently to avoid this error?

if (isset($_POST['end'])) {
    foreach ($_POST['items'] as $checked) {
        $sql = "UPDATE oeprcfil_sql SET end_dt=? WHERE cd_tp_1_cust_no =? AND cd_tp_1_item_no =? AND ID =?";
        $prepare = odbc_prepare($conn, $sql);
        $end_dt = $checked['end_dt'];
        $cus_no = $checked['cus_no'];
        $item_no = $checked['item_no'];
        $id = $checked['ID'];

        odbc_execute(
            $prepare,
            array($end_dt, $cus_no, $item_no, $id)
        );
    }
}

edited Jul 19 '16 at 18:11

Danila Ganchar

10,266
13
49
75

asked Jul 19 '16 at 15:33

Ryan

1

Try this answer here: http://stackoverflow.com/a/24651612/4875631 – Blue Jul 19 '16 at 15:37
1

In short, make sure your date/time format is correct. – apokryfos Jul 19 '16 at 15:38
BINGO...Is there a way to convert 08/15/2015 to this 2015-08-15 in php after grabbing user input? – Ryan Jul 19 '16 at 15:42
Never mind http://stackoverflow.com/questions/10306999/php-convert-date-format-dd-mm-yyyy-yyyy-mm-dd – Ryan Jul 19 '16 at 15:46

How to correctly prepare and execute an odbc connection

0 Answers0