Hi,
In my query string I have '?' characters which I want to replace by
parameters:
$sql =
'SELECT COUNT(*) FROM contact_detail D, girls G, partners P ' .
'WHERE D.girl_id = G.id_girl ' .
'AND D.member_confirmed = 1 ' .
'AND G.partner_id = ? ' .
'AND D.isRead = ?';
$this->view->notReadContacts = $db->fetchOne($sql,
array($auth->getIdentity()->id_partner, 0));
The problem is that when I use the profiler, I get the following query:
Executed SELECT COUNT(*) FROM contact_detail D, girls G, partners P WHERE
D.girl_id = G.id_girl AND D.member_confirmed = 1 AND G.partner_id = ? AND
D.isRead = ?
The parameters are not replaced.
Thank you for any help !!
--
View this message in context:
http://www.nabble.com/fetchOne-issue-tp17598514p17598514.html
Sent from the Zend Framework mailing list archive at Nabble.com.
