Pretty sure you can use named bindings:
$table->select()->where( 'SHA1( CONCAT( :salt, ip ) ) = :ip',
array('salt'=>$salt, 'ip' => $data['ip' ] ) );Deepak Shrestha wrote: > > On Mon, Feb 23, 2009 at 8:59 PM, <[email protected]> wrote: >> Hi all, >> >> I'm trying to accomplish the following with a Zend_Db_Table_Select >> statement: >> >> $table->select()->where( 'SHA1( CONCAT( ?, ip ) ) = ?', array( $salt, >> $data[ >> 'ip' ] ) ); >> >> In other words, I am trying to get a where clause to accept multiple >> placeholder values. Is something like this possible? If not, any other >> (sleek) suggestions? Thanks in advance! >> >> FireEyed >> >> ________________________________ >> Meer dan chatten alleen. Check nu de nieuwe Windows Live > > Though my problem is not exactly yours, what I did was I created a > WHERE caluse in a variable and then passed it to select. > > ============== > $whereclause = "SHA1(CONCAT(" . $salt . "," . "ip)) = " . $data['ip'] ; > > $table-$select->where($whereclause); > ============= > > don't know if it is helpful > > have a look at my previous post > http://www.nabble.com/Multiple-pattern-match-with-Zend_Db_Table_Select-td22134565.html > > regards! > > -- > ======================= > Registered Linux User #460714 > Currently Using Fedora 8, 10 > ======================= > > -- View this message in context: http://www.nabble.com/Multiple-placeholders-in-select%28%29-%3Ewhere%28%29-clause--tp22161067p22163010.html Sent from the Zend Framework mailing list archive at Nabble.com.
