PDO - Output SQL from a Prepare

[cheesey_toastie]

Hi,

i'd like to echo out the SQL that my PDOstatement 'object' has before I execute it. I'm sure I've found this before but my Google searches are not turning anything up this time around...

$query = self::$db->prepare("UPDATE users SET lastLogin = :timeNow WHERE ID = :userID");
$query->bindParam(':timeNow', $timeNow);
$query->bindParam(':userID', $this->userID);

// **
// ** I want to echo $query->outputSQL or whatever...
// **

$query->execute();	

I'm sure I'm missing an easy method somewhere??

CT

[laserlight]

I don't think such a thing exists, but that should not be a problem since you have the SQL statement in unprepared form, as well as the variables used. PDO::errorInfo() can also be used to help you debug.