[Zope] mySQL and Zope and multiple databases

[Schmidt, Allen J.]

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 )