[Zope] connect to multiple mysql db's question

Chris Withers chrisw@nipltd.com
Fri, 16 Aug 2002 11:01:02 +0100


Greg Conway wrote:
>  
> Can I run a query in Zope combined across two different MySQL connectors?
>  

No

> My best guess so far is to create two seperate queries, each using one 
> Database, then a third query to join these two queries.... somehow!!

Have two DTML methods, which each do the query on the appropriate connection, 
then write a python script to call both methods and combine the results.

cheers,

Chris

PS: Please don't post in HTML and see if you can loose that nasty spammy footer ;-)