Hi Chris,

Thanks, is this code still efficient if the tables relate to 1:1 and you
need to show a list of all records in a tabulare table?

eg key, NAME, ALIAS, ....

where NAME is from database1 and ALIAS is from database2

The code below would impact that for every record in database1, I've to
query database2
Is there another way to do this? (more efficient?, ie less database query)

Tom.

----- Original Message -----
From: "Chris Gray" <[EMAIL PROTECTED]>
To: "Tom Deprez" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, December 04, 2000 3:45 PM
Subject: Re: [Zope] ZSQLMethods


> You want something along these lines:
>
> <dtml-in selectFromTable1>
>    <dtml-in expr="selectFromTable2(id=_['id'])">
>       ....display record....
>    </dtml-in>
> </dtml-in>
>
> This would be more efficient than pulling out the whole of two tables.
>
> Chris
>
> On Mon, 4 Dec 2000, Tom Deprez wrote:
>
> > Hi,
> >
> > I'm wondering how the following can be done.
> >
> > I've 2 databases. I want to do a 'join' with 2 tables, both in a
different
> > database.
> > Is it possible to retrieve data of both tables with a ZSQLMethod and
then
> > do a programatically join? What's the easiest python way?
> >
> > Thanks, Tom.
> >
> > _______________________________________________
> > Zope maillist  -  [EMAIL PROTECTED]
> > http://lists.zope.org/mailman/listinfo/zope
> > **   No cross posts or HTML encoding!  **
> > (Related lists -
> >  http://lists.zope.org/mailman/listinfo/zope-announce
> >  http://lists.zope.org/mailman/listinfo/zope-dev )
> >
>
>
> _______________________________________________
> Zope maillist  -  [EMAIL PROTECTED]
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
>


_______________________________________________
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to