FuelPHP Forums

Here is the current db connection config:

'default' => array(
  'type'        => 'pdo',
  'connection'  => array(
                        'dsn'        => 'odbc:GLOBAL',
   'username'   => '',
   'password'   => '',
   'persistent' => true,
  ),
  'identifier'   => '',
  'table_prefix' => '',
  'charset'      => '',
  'enable_cache' => true,
  'profiling'    => true,
 )

I've written some code in a Rest controller to simply display part information. I wanted to be sure that the connections worked before I started to do anything serious.

$part = (int) Input::get('part');
        $query = DB::select('columns')->from('table')->where('part', $part);
        $data = $query->execute();
if(DB::count_last_query() === 0) {
            $this->response(array('server_message' => 'No parts were found matching that request.'));
        }
        else{
          $this->response($data->as_array());   
        }

The question, and the odd thing that happens, is if I set $part = 32010 it returns the dataset just fine. If I set $part = 20, which isn't in the db, it returns the "server_message" with no problems. However if I set it to certain values, lets say 1 or 61, it throws a DB exception instead. 1 and 16 also should return no results. PDOException [ 22018 ]: SQLSTATE[22018]: Invalid character value for cast specification: 0 [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Error in assignment. (SQLFetchScroll[0] at ext\pdo_odbc\odbc_stmt.c:537) Most of the searching I've done returns issues with "date" datatypes. It's almost as if at some point its converting it back to another datatype...or just not passing it through at all. Any help is appreciated!