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

If you only want specific rows from the original table, you can call from():

$table = new MyTable();

$select = $table->select()
->setIntegrityCheck(false)
->from($table, array('id', 'name'))
->join(...);

Does that help?

-Hector

On Fri, Feb 13, 2009 at 9:30 AM, lightflowmark <1@lightflowinterrupted.com> wrote:

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.