Thanks to yall...
Finally, I thought like you Randy... I created as many folders as many
servers I have. Each folder contains a connection object called "con"
every where. Each folder contains also Z SQL Methods. Some of them
contains the same Z SQL Methods. So, I just have to specify the server I
want to connect to and use directly the Z SQL Method I want.
My folders (called like my servers) are Transparent Folder. So, I can
call directly some Z SQL Methods which are available only on one
Randall Kern wrote:
> I haven't actually tried this, but it seems it should work:
> /db1 - folder
> connection - a DB connection object to db 1
> /db2 - folder
> connection - a DB connection object to db 2
> query - a ZSqlMethod, set to use the connection 'connection'. Note,
> you may have to add a temporary DB connection to the root, to allow you to
> setup these methods. After you have created your methods, remove the
> /connection object.
> Then use urls like http://your.server/db1/query to run the query using the
> first database connection, and http://your.server/db2/query to run query
> using the second database connection.
> ----- Original Message -----
> From: "Tino Wildenhain" <[EMAIL PROTECTED]>
> To: "Frederic Quin" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, December 05, 2000 4:56 AM
> Subject: Re: [Zope] How to specify to z sql methods, the connection object
> to use at runtime...time...
> > Hi Frederic,
> > Frederic Quin schrieb:
> > >
> > > Hi all,
> > >
> > > I have the same querry to execute on different servers. I don't want to
> > > create as many z sql methods as servers I have. I would like to specify
> > > to my z sql method, the connection object to use at run time. Do I have
> > > to patch the files of z sql methods ? Can I use directly the connection
> > > object ??
> > A clean approach would be subclassing the zsql-method
> > for your purpose. I would not recommend a free-form
> > string as argument for the Datasource. May be an integer index
> > (first, second, third... database server)
> > or something like that?
> > Regards
> > Tino
> > _______________________________________________
> > Zope maillist - [EMAIL PROTECTED]
> > http://lists.zope.org/mailman/listinfo/zope
> > ** No cross posts or HTML encoding! **
> > (Related lists -
> > http://lists.zope.org/mailman/listinfo/zope-announce
> > http://lists.zope.org/mailman/listinfo/zope-dev )
Zope maillist - [EMAIL PROTECTED]
** No cross posts or HTML encoding! **
(Related lists -