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

Collapse
2: Re: querying multiple datababe server.. (response to 1)
Posted by Cheng-Yi Hsu on 11/25/02 02:56 AM 
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 !