• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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?


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.