Re: [RDBO] Relationships and queries across multiple databases

2007-10-02 Thread John Siracusa
On 10/1/07 11:06 PM, Kurt Hansen wrote: >> Have you tried simply setting the "schema" attribute of your Rose::DB data >> sources? >> > Yes, I've done the following: > > __PACKAGE__->register_db( > domain => 'pax', > type => 'donor', > ... > schema => '1', > );

Re: [RDBO] Relationships and queries across multiple databases

2007-10-01 Thread Kurt Hansen
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

Re: [RDBO] Relationships and queries across multiple databases

2007-10-01 Thread John Siracusa
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 -- :-), > e

Re: [RDBO] Relationships and queries across multiple databases

2007-10-01 Thread Kurt Hansen
Hello, 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 R

[RDBO] Relationships and queries across multiple databases

2007-09-26 Thread Kurt Hansen
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 hav