View Active Record Query String?

[eluser]jcavard[/eluser]
[quote author="Travis O" date="1249512308"]You could also use profiling to display the query as it is run on the page.

http://ellislab.com/codeigniter/user-gui...iling.html[/quote]
the profiling is really useful, but I was not aware of this one

Code:

$this->db->_compile_select();

and that is mervelous!
thanks