[Zope] ZSQLMethods

[Chris Gray]

Just had a few additional points:

Should be <dtml-if idFromTable1 == idFromTable2> of course.

You'll have problems if columns have the same name in the two tables.  You
may have to modify ZSQL methods from 'select column_name' to 'select
column_name as distinct_name' to get around this.

Chris


On Mon, 4 Dec 2000, Chris Gray wrote:

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