[Zope] Multiple ZODBC sources

[Chris Gray]

I wonder if something like this would work:

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

Might be more efficient to make one of the dtml-ins a dtml-with and find
the item with the matching id.

Interesting problem, I wish I had some time to play around with it.

Chris


On Thu, 23 Nov 2000, Andrew Kenneth Milton wrote:

> +-------[ Capesius, Alan ]----------------------
> | I need to join tables from two ODBC sources, one MS Access one SQL. 
> | 
> | ZODBC DA seems to be limited to one data source at a time. Is there any way
> | to join tables from two different sources?
> 
> Write a method to copy the results from Access into a temporary table of the 
> other.
> 
> Then do your query and clean up.
> 
> -- 
> Totally Holistic Enterprises Internet|  P:+61 7 3870 0066   | Andrew Milton
> The Internet (Aust) Pty Ltd          |  F:+61 7 3870 4477   | 
> ACN: 082 081 472 ABN: 83 082 081 472 |  M:+61 416 022 411   | Carpe Daemon
> PO Box 837 Indooroopilly QLD 4068    |akm@theinternet.com.au| 
> 
> _______________________________________________
> 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 )
>