active record class: print sql

[eluser]sl3dg3hamm3r[/eluser]
Hey there

Is there a function in the active record class which might give me back the plain sql which would be sent to the DB?

furthermore:
Is there a way to reset setted rules like
$this->db->where('')
?

Or is it anyhow resetted after $this->db->get()?

Sl3dg3

[eluser]m4rw3r[/eluser]

Code:

echo $this->db->_compile_select();

Returns the SQL.

The reset is harder, but you can always directly clear the properties (and yes, it is reset after get()).

[eluser]sl3dg3hamm3r[/eluser]
cool, thx!