Active Record Cache doesn't work with delete

[eluser]JeffChan[/eluser]
[quote author="inparo" date="1218221464"]Active Record clears after every query it runs, so the where clause is gone when the second delete query runs.

Code:

$tables = array('projects', 'comments', 'media');
$this->db->where('id', $this->uri->segment(3));
$this->db->delete($tables);

Also, in my mind delete counts as a 'write-type' query..::confused::

Only read-type (SELECT) queries can be cached,

[/quote]

Yeah that's correct, but keep in mind here that we're caching the "where" query not the "delete" query.

So theoretically, the where clause should have been cached when using $this->db->start_cache()/$this->db->stop_cache() and applied to subsequent queries until a flush.

Edit: Oops sorry. I think we're not on the same page... I was refering to the Active Record Cache not the database query cache.