Dear list<br><br>Thank you for all your replies and appreciate your comments given.<br><br>CY<br><br><b><i>Andrew Veitch <andrew@logicalware.com></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> If you add a ZSQL Method and then go to the 'Advanced' tab you can <br>specify a 'Connection Hook'. This should be the name of a Python <br>Script or some other method which will return the name of the <br>database connection to use allowing you to dynamically change the DB <br>connection.<br><br>A<br><br>On 9 Jun 2006, at 06:19, Infor Gates wrote:<br><br>> My apologies if my query is unclear.<br>> M.Banaouas got it right. Let try to explain it another way:<br>> 1. We have a standard Zope application which is replicated in ZMI.<br>> 2. the difference in each Zope application is DBconnection.<br>> 3. Each DBconnection is connection to each Branch database.<br>><br>> In other
words, if I have 10 branches, I will replicate 10 times of <br>> the<br>> same Zope application which is not a wise thing to do. As such,<br>> I exploring to find a way if there is "dynamically" way to<br>> change the db connection to the intended (branch) database.<br>> Thus eliminating the Zope application replication.<br>><br>> Thank you.<br>><br>> CY<br>><br>> -----<br>> > May be "dynamically database connection" means that we use the same<br>> "Z<br>> > SQL Method" with different database connections (in the same Zope<br>> > Instance, of course). So we can change "dynamically" from one<br>> database<br>> > to another (schema-equal).<br>> ><br>> > In other words, is it possible to define "database connection"<br>> property<br>> > of a "Z SQL Method" like we do for parameters ?<br>> __________________________________________________<br>> Do You Yahoo!?<br>> Tired of spam?
Yahoo! Mail has the best spam protection around<br>> http://mail.yahoo.com<br>><br>> _______________________________________________<br>> Zope-DB mailing list<br>> Zope-DB@zope.org<br>> http://mail.zope.org/mailman/listinfo/zope-db<br><br><br></blockquote><br><p> __________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com