PDO in Codeigniter

[eluser]Ickes[/eluser]
Thanks Chad. This wasn't working but I assume this
[quote author="Chad Fulton" date="1246921367"]

Code:

$data = $this->db->execute();

[/quote]

should be

Code:

$data = $stmt->execute();

.

Well that executes but it never returns a result set. If I print_r($stmt), I receive the query but with the unbound variable :test

PDOStatement Object ( [queryString] => SELECT * FROM tbl_blog WHERE blog_id = :test )

If I print_r($data) in the model or the controller, it returns nothing.

So now what am I missing? I can create a PDO connection and execute a query but the result set returns nothing. Maybe Active Record is best but I'm not ready to give up yet.