2009年2月13日星期五

Re: [fw-mvc] partialLoop & Zend_Db_Table_Rowset as object usage

Hi,
No, I don't think that works either. Your example still returns all the
rows in the table MyTable, regardless of the join conditions, as documented
in
http://framework.zend.com/issues/browse/ZF-2925
Certainly it did when I just tried it! PLMK if it's working for you, maybe
it's something I'm doing.

As I understand it, setIntegrityCheck is only used so you can return rows
from your joined tables, so that your returned Zend_Db_Table_Row object
doesn't actually represent a row from a single table, e.g. for a query like
SELECT table1.*,table2.* FROM .... the Zend_Db_Table_Row object contains all
the columns from table1 as well as all the columns from table2. Although
I've never used it myself!

Yours,
Mark

You can join on a table object if you call setIntegrityCheck(false) on the
select object:

$table = new MyTable();
$select = $table->select()
->setIntegrityCheck(false)
->join(...);

-Hector


--
View this message in context: http://www.nabble.com/partialLoop---Zend_Db_Table_Rowset-as-object-usage-tp21994862p22001033.html
Sent from the Zend MVC mailing list archive at Nabble.com.

没有评论: