[fw-general] Zend_Db -> last query with values

[Mark Steudel]

Hi All,

 

I was wondering if it was possible to get back the last run query including
the values that get swapped in place of the ?

 

E.g. if I did:

$id = 4;

 

$sql = "SELECT id FROM table WHERE id = ?";

                        

$rows = $this->db->fetchAll( $sql, $id );

 

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

 

It would spit back SELECT id FROM table WHERE id = 4.

 

I tried using the profiler, but it just gives me back the sql statement
before $id gets passed into it.

 

Thanks, Mark