[Zope] ZSQLMethods

[Chris Gray]

Try something like:

<dtml-in selectFromTable1>
  <dtml-in selectFromTable2>
     <dtml-if idFromTable1 = idFromTable2>
        ....display parts of the two records....
     </dtml-if>
  </dtml-in>
</dtml-in>

This keeps it to two db queries and the join work is done by Zope.

Chris

On Mon, 4 Dec 2000, Tom Deprez wrote:

> 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 )
> >
>