[Zope-DB] multidatabase connections

[Chris Withers]

srikanth wrote:
> But with Zmysql database connection object I can connect to only one
> database. So how do I use my two databases to query at the 
> Same time. 

Have two ZMySQLDA objects, one connection to each of your databases.

If you really want to do a single SQL statement that uses both 
databases, then I think you need to merge the databases in MySQL or do 
two SQL statements and manually combine the two result sets (often very 
inefficient)...

cheers,

Chris

> 
>  
> 
>    Any help would be greatly appreciated. 
> 
>  
> 
>  Ta.
> 
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.859 / Virus Database: 585 - Release Date: 2/14/2005
>  
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Zope-DB mailing list
> Zope-DB at zope.org
> http://mail.zope.org/mailman/listinfo/zope-db

-- 
Simplistix - Content Management, Zope & Python Consulting
            - http://www.simplistix.co.uk