Hy Shekar,

this is not supported, and it was not supported in the past.
Because ? is a placeholder for only ONE variable.
And you gave two within your array :-)

Actually I am working on a array integration which adds several new features to where. But the behaviour you are expecting would break things with other new where features.

For now it is not planned to support such a use case.

Btw: Before my improvement several days ago even the first variable would not have been integrated. That the array value is inserted for a placeholder is also one of the new features :-)

Greetings
Thomas
I18N Team Leader

----- Original Message ----- From: "Shekar C Reddy" <[EMAIL PROTECTED]>
To: "Zend Framework General" <[email protected]>
Sent: Tuesday, November 20, 2007 10:55 AM
Subject: [fw-general] Zend_Db_Select::where() malfunction


Bill,

I downloaded the latest SVN today and noticed a strange behavior with the
select component:

$select->where( 'status IN ( ? )', array( 'A', 'I' ));


SQL generated:

WHERE status IN ( 'A' )


SQL expected:

WHERE status IN ( 'A', 'I' )


Reply via email to