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 )