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
=======================
