RE: [Zope] Multiple ZODBC sources

2000-11-22 Thread Capesius, Alan
PROTECTED]] >>>Sent: Wednesday, November 22, 2000 10: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: >

Re: [Zope] Multiple ZODBC sources

2000-11-22 Thread Chris Gray
Another thing that would work: display record 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 > > Phil > - Original Message - > From: "Capesius, Alan" <[EMAIL PROTECT

Re: [Zope] Multiple ZODBC sources

2000-11-22 Thread Chris Gray
I wonder if something like this would work: display parts of the two records 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 O

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

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 into