[Zope-dev] Re: [Zope] present data from db (multiple tables) using zpt

[Michael Long]

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.