John Siracusa wrote: > On 10/1/07 1:17 PM, Kurt Hansen wrote: > >> Hmm...I'm not sure if the lack of response on this question is because >> no-one is doing this, it isn't possible within RDBO, my e-mail was last, >> or my question was incoherent. >> >> While the incoherence of the message is a definite possibility -- :-), >> even knowing this isn't possible within RDBO would be most helpful! >> > > Have you tried simply setting the "schema" attribute of your Rose::DB data > sources? > > -John > > Yes, I've done the following:
__PACKAGE__->register_db( domain => 'pax', type => 'donor', ... schema => '1', ); I tried it, and it didn't seem to work. I also tried setting the schema to the database name and that didn't work either. What should I be doing? Thanks! Take care, Kurt >> Kurt Hansen wrote: >> >>> Hello, >>> >>> I'd like to be able to setup relationships and do queries across two >>> databases. >>> >>> The archives of this mailing list suggests this is possible with >>> mentions of "supports_schema" and a schema parameter call in the >>> Rose::DB->register_db call. >>> >>> Unfortunately, the details of how to do this have avoided my muddled >>> brain even though I have tried to capture them by searching the docs, >>> searching via Google, and experimentation. >>> >>> My database is MySQL. >>> >>> Any help, including a pointer to where in the docs I should have found >>> it, would be much appreciated. :-) >>> >>> Take care, >>> >>> Kurt Hansen >>> [EMAIL PROTECTED] >>> ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object