[eluser]Frank Rocco[/eluser]
Hello,
The code below worked in prior version of CI.
Am I doing something wrong?
Thanks
Frank
config.php
$db['as400']['hostname'] = "xx.xx.xx.xxx";
$db['as400']['username'] = "TEST";
$db['as400']['password'] = "TEST";
$db['as400']['database'] = "AS400";
$db['as400']['dbdriver'] = "odbc";
$db['as400']['dbprefix'] = "";
$db['as400']['active_r'] = FALSE;
$db['as400']['pconnect'] = FALSE;
$db['as400']['db_debug'] = TRUE;
index
$DB2 = $this->load->database('as400', TRUE);
$sql = "SELECT S1090B3E.BSYDTAA.BSYPEMP.EMYLNM FROM BSYDTAA.BSYPEMP ";
$sql .= " FETCH FIRST 20 ROWS ONLY";
$query = $DB2->query($sql);
// fails here
$row = $query->row_array();
// or here
foreach ($query->result() as $row)
{
echo $row->EMYLNM . "<br/>";
}