Welcome Guest, Not a member yet? Register   Sign In
how do you use active record to query rowid from oracle?
#1

[eluser]kimo_gusatava[/eluser]
I tried useing
Code:
$this->db->select('rowid, *');
        $this->db->from('EMPLOYEES');
        $this->db->where('EMPLOYEE_ID', $id);

result:
Code:
A Database Error Occurred

Error Number:

SELECT "rowid", * FROM "EMPLOYEES" WHERE "EMPLOYEE_ID" = '100'

also tried

Code:
$this->db->select('ROWIDTOCHAR(rowid), *');
        $this->db->from('EMPLOYEES');
        $this->db->where('EMPLOYEE_ID', $id);

result:
Code:
A Database Error Occurred

Error Number:

SELECT ROWIDTOCHAR(rowid), * FROM "EMPLOYEES" WHERE "EMPLOYEE_ID" = '100'

any help on this?




Theme © iAndrew 2016 - Forum software by © MyBB