connect to multiple mysql db's question
Hi all, Just a quickie... In order for me to organise my sites a little better, I'd like to seperate out some of my Databases. Can I run a query in Zope combined across two different MySQL connectors? 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!! I'm hoping there's an easier way!! Any suggestions gratefully received! Regards, Greg Conway. This electronic transmission and any files attached to it are strictly confidential and intended solely for the addressee. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify us by return and delete the same. Further enquiries/returns can be posted to postmaster@gmlnt.com Thank you.
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 ;-)
participants (2)
-
Chris Withers -
Greg Conway