Zend Db joinLeft with parameterized value

Question

I need to joinLeft within Zend_Db ala:

$select->joinLeft(array('ATAG' => 'ad_tags'),
                  array('ADM.id = ATAG.ad_id AND ADM.site_id = ATAG.site_id AND ATAG.tag_id = ?', $input_vars['tag']),
                  array('tag_id'))
       ->order('ATAG.tag_id DESC')
       ->limit('1');

However, I can't use an array as the second parameter, because it only tags a string; how can I pass in the value, without actually embedding it in the string?

Answer 1

Based on your example you need to use quoteInto (considering you're in Zend_Db_Table):

$select->joinLeft(array('ATAG' => 'ad_tags'),
                  'ADM.id = ATAG.ad_id AND ADM.site_id = ATAG.site_id AND ' . 
                  $this->getAdapter()->quoteInto('ATAG.tag_id = ?',$input_vars['tag']),
                  array('tag_id'))
       ->order('ATAG.tag_id DESC')
       ->limit('1');

You can also do the same with:

$select->from(array('ADM' => 'adm_table'),'*')
       ->joinLeft(array('ATAG' => 'ad_tags'), 'ADM.id = ATAG.ad_id', 'ATAG.tag_id')
       ->where('ADM.site_id =ATAG.site_id')
       ->where('ATAG.tag_id = ?',$input_vars['tag'])
       ->limit(1);

If you're in Zend_Db_Table you need to set

$select->setIntegrityCheck(false);

(Note that adm_table is just an example, since you did not tell me the table name)