Create your sql statement to return the data from the 2 tables in one
row joining the 2 tables on a uniquekey that is common to both tables.
select table1.col1, table1.col2, table2.col3, table2.col6
from table1 join table2
on table1.<uniquekey> = table2.<uniquekey>
hth,
Mike
On Fri, 2003-07-04 at 10:57, Exteam wrote:
> Hi,
> we are having a problem while presentation of values retreived from
> multi tables(from mysql) in ZPT we use zsql to retreive from each
> individual table. But while presentation part comes, we are unable to
> position the values from multi table in a single row .
> As it is apparant that a tr can repeat only a single table at a time
> by the tal functions.
>
> what we had tried is
> <tr repeat='item python:container.zsqlmethodname() >
> We want the Zpt to repeat more than one table in a single row.
> So that we could retreive the requisite values from the tables and
> present it.
>
> How can it be resolved.
> Thanks
> exteam
>
>
> Yahoo! India Mobile SMS using the Yahoo! Messenger; Download latest
> version.
_______________________________________________
Zope-Dev maillist - [EMAIL PROTECTED]
http://mail.zope.org/mailman/listinfo/zope-dev
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope )
