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" <[EMAIL PROTECTED]>
To: "senkr" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> 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.
>
>
___
Zope-Dev maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope )