[Zope-dev] Multiple Database Connections Same Zsql method

[senkr]

Thanks for the assist.  This worked very well.  Definitely have to delete
the db connection which lies in the directory with the zsql method.

Thanks much!!

Rob
----- Original Message -----
From: "Adrian Hungate" <adrian@haqa.co.uk>
To: "senkr" <senkr@attbi.com>; <zope-dev@zope.org>
Sent: Sunday, March 10, 2002 11:53 PM
Subject: Re: [Zope-dev] Multiple Database Connections Same Zsql method


> The easiest way to do this is probably (As I think you are describing) put
> the ZSQL Method in a folder, and put one database connection in each
> sub-directory, and have all the database connectors with the same name.
>
> The problem with this will be that you will have to create a database
> connection in the folder with the ZSQL Method just so you can write the
> method (ZSQL Methods insist on giving you your database connection). Then
> you will have to delete the connection BEFORE you can use the others via
> acquisition.
>
> Not tested, but in theory it should work.
>
> Adrian...
>
> --
> The difficulty of tactical maneuvering consists in turning the devious
into
> the direct, and misfortune into gain.
> - Sun Tzu
>
>
> ----- Original Message -----
> From: "senkr" <senkr@attbi.com>
> To: <zope-dev@zope.org>
> Sent: Saturday, March 09, 2002 12:10 AM
> Subject: [Zope-dev] Multiple Database Connections Same Zsql method
>
>
> Is it possible to iterate though multiple databases with the same zsql
> method?  Have multple identical databases with different data.  Want to
> maintain only one method.
>
> Can i do this in DTML or do I have to use pythonscripts?
>
> I guess what I want to do is to have the query in one folder, call it from
> another folder and pass the database connection info to it.
>
> Not sure how well this would work with multiple users though.......
>
> Any advice is appreciated.
>
>