[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 ''