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? Alan Capesius, MCSE+20 Technical Support Engineer Sysmex Corporation of America capesiusa@sysmex.com
+-------[ 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|
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 )
Link the SQL table into Access and then use both from Zodbcda connected to Access. hth Phil ----- Original Message ----- From: "Capesius, Alan" <CapesiusA@Sysmex.com> To: <zope@zope.org> Sent: Wednesday, November 22, 2000 3:56 PM Subject: [Zope] Multiple ZODBC sources
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?
Alan Capesius, MCSE+20 Technical Support Engineer Sysmex Corporation of America capesiusa@sysmex.com
_______________________________________________ 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 )
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
Phil ----- Original Message ----- From: "Capesius, Alan" <CapesiusA@Sysmex.com> To: <zope@zope.org> Sent: Wednesday, November 22, 2000 3:56 PM Subject: [Zope] Multiple ZODBC sources
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?
Alan Capesius, MCSE+20 Technical Support Engineer Sysmex Corporation of America capesiusa@sysmex.com
_______________________________________________ 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 )
participants (4)
-
Andrew Kenneth Milton -
Capesius, Alan -
Chris Gray -
Phil Harris