Re: [Zope] Multiple ZODBC sources

2000-11-22 Thread Andrew Kenneth Milton
+---[ 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

Re: [Zope] Multiple ZODBC sources

2000-11-22 Thread Phil Harris
Link the SQL table into Access and then use both from Zodbcda connected to Access. hth Phil - Original Message - From: "Capesius, Alan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 22, 2000 3:56 PM Subject: [Zope] Multiple ZODBC sources I need to join tables from

Re: [Zope] Multiple ZODBC sources

2000-11-22 Thread 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

Re: [Zope] Multiple ZODBC sources

2000-11-22 Thread Chris Gray
Another thing that would work: dtml-in selectFromTable1 dtml-in expr="selectFromTable2(id=_['id'])" display record /dtml-in /dtml-in Chris On Wed, 22 Nov 2000, Phil Harris wrote: Link the SQL table into Access and then use both from Zodbcda connected to Access. hth

RE: [Zope] Multiple ZODBC sources

2000-11-22 Thread Capesius, Alan
:31 AM To: Andrew Kenneth Milton Cc: Capesius, Alan; [EMAIL PROTECTED] Subject: Re: [Zope] Multiple ZODBC sources I wonder if something like this would work: dtml-in selectFromTable1 dtml-in selectFromTable2 dtml-if idFromTable1 = idFromTable2 display parts of the two records