[Zope] ZSQLMethods

[Tom Deprez]

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" <cpgray@library.uwaterloo.ca>
To: "Tom Deprez" <tom.deprez@uz.kuleuven.ac.be>
Cc: <zope@zope.org>
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  -  Zope@zope.org
> > 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  -  Zope@zope.org
> 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 )
>