Forum OpenACS Q&A: Re: querying multiple datababe server..

Posted by Cheng-Yi Hsu on
I use this to query no-default pool,
db_with_handle yourpool {
    db_foreach yoursql "...." {
    db_string yoursql ...
    db_1row ...
    other new ACS4.x db api

, and in your servicename.tcl ns/server/yourservicename/db section,
ns_param pool yourpool,main,subquery,log

make sure yourpool in first order, otherwise some strang error will happen !