Yes, this is what I mean. I can do it from the mySQL admin tool just fine. I will look into external methods then. Thanks! -----Original Message----- From: Eric Walstad [mailto:eric@walstads.net] Sent: Tuesday, August 07, 2001 1:35 PM To: Schmidt, Allen J.; Zope mailing list Subject: RE: [Zope] mySQL and Zope and multiple databases Allen, I just reread your message and I think misunderstood it the first time. The link I sent before describes querying two databases, not querying against two MySQL Database connections in one ZSQL method... This kind of query could be run from an external method that queries the two databases and returns the result set to Zope, tho. I think that would do what you need. As each ZSQL method has one database connection property, I'm not sure how, or if, you could specify using two database connections in one ZSQL method. Eric.

-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Eric Walstad Sent: Tuesday, August 07, 2001 10:19 AM To: Schmidt, Allen J.; Zope mailing list Subject: RE: [Zope] mySQL and Zope and multiple databases

Hi Allen, I haven't done it myself, but I may need to before long. :) So, I just did a quick Google search and found: http://www.ultraviolet.org/mail-archives/mysql.1999/0323.html I'd be interested to hear if this works for you. Eric.

...

-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Schmidt, Allen J. Sent: Tuesday, August 07, 2001 5:26 AM To: Zope mailing list Subject: [Zope] mySQL and Zope and multiple databases

We are moving a bunch of stuff to mySQL. One database currently exists and some of the new tables that need to be brought in have the same names. If I create a new database to house the new tables, how can I use ZSQL methods to compare fields in tables between two ZmySQL connections?

Thanks

_______________________________________________ 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 )