[Zope] connect to multiple mysql db's question
Greg Conway
greg@gmlnt.com
Fri, 16 Aug 2002 07:39:08 +0100
This is a multi-part message in MIME format.
------=_NextPart_000_0077_01C244F8.017EF1B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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.
------=_NextPart_000_0077_01C244F8.017EF1B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D657052706-16082002><FONT face=3DArial size=3D2>Hi=20
all,</FONT></SPAN></DIV>
<DIV><SPAN class=3D657052706-16082002><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D657052706-16082002><FONT face=3DArial =
size=3D2>Just a=20
quickie...</FONT></SPAN></DIV>
<DIV><SPAN class=3D657052706-16082002><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D657052706-16082002><FONT face=3DArial size=3D2>In =
order for me to=20
organise my sites a little better, I'd like to seperate out some of my=20
Databases.</FONT></SPAN></DIV>
<DIV><SPAN class=3D657052706-16082002><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D657052706-16082002><FONT face=3DArial size=3D2>Can I =
run a query in=20
Zope combined across two different MySQL connectors?</FONT></SPAN></DIV>
<DIV><SPAN class=3D657052706-16082002><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D657052706-16082002><FONT face=3DArial size=3D2>My =
best guess so far=20
is to create two seperate queries, each using one Database, then a third =
query=20
to join these two queries.... somehow!!</FONT></SPAN></DIV>
<DIV><SPAN class=3D657052706-16082002><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D657052706-16082002><FONT face=3DArial size=3D2>I'm =
hoping there's=20
an easier way!!</FONT></SPAN></DIV>
<DIV><SPAN class=3D657052706-16082002><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D657052706-16082002><FONT face=3DArial size=3D2>Any =
suggestions=20
gratefully received!</FONT></SPAN></DIV><SPAN =
class=3D657052706-16082002>
<DIV><BR><FONT face=3DArial size=3D2>Regards,</FONT></DIV>
<DIV><BR><SPAN class=3D657052706-16082002><FONT face=3DArial =
size=3D2>Greg=20
Conway.</FONT></SPAN></SPAN></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML>
<BR>This electronic transmission and any files attached to it are strictly
<BR>confidential and intended solely for the addressee. If you are not
<BR>the intended addressee, you must not disclose, copy or take any action
<BR>in reliance of this transmission. If you have received this
<BR>transmission in error, please notify us by return and delete the same.
<BR>Further enquiries/returns can be posted to postmaster@gmlnt.com
<BR>Thank you.
------=_NextPart_000_0077_01C244F8.017EF1B0--