CodeIgniter Forums
Can't use Like clause with Active records and oci8 - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Can't use Like clause with Active records and oci8 (/showthread.php?tid=34282)



Can't use Like clause with Active records and oci8 - El Forum - 09-24-2010

[eluser]imorris[/eluser]
I'm having trouble using the Like clause with Active Records and OCI8. When I try to do them it gives me an error about an escape character.

Here's what I'm using in my Model.
Code:
function get_changes($searchstring)
    {  
    $this->db->like("ASSETNAME", $searchstring);
    $query = $this->db->get('ASSET');
        return $query;
    }

Here's the error I'm getting.
Code:
A PHP Error was encountered

Severity: Notice

Message: Undefined property: CI_DB_oci8_driver::$_like_escape_char

Filename: database/DB_active_rec.php

Line Number: 728


A Database Error Occurred

Error Number:

SELECT * FROM "ASSET" WHERE "ASSETNAME" LIKE '%Server%' escape ''