View query before being executed?

[eluser]jrlooney[/eluser]
Hello,

How can I dump the query that $this->db is going to execute so that I can review it?

So, for example, for this query, I'd like to see the SQL (even if I just var_dump it):

Code:

$this->db->limit(0,$this->per_page);
$this->db->select('contact_id,first_name,last_name');
$data['query'] = $this->db->get('cm_contact');

thanks in advance