Re: [RDBO] Unable to query using sub-tablename

2007-07-09 Thread John Siracusa
On 5/25/07, James Masters <[EMAIL PROTECTED]> wrote: > > Table or relationship names can be used in the value of the "query" > > parameter, but the with_objects and require_objects parameters only > > accept foreign key and relationship names. I think the error you got > > is because you put produ

Re: [RDBO] Unable to query using sub-tablename

2007-05-25 Thread James Masters
> Table or relationship names can be used in the value of the "query" > parameter, but the with_objects and require_objects parameters only > accept foreign key and relationship names. I think the error you got > is because you put productlocs in your with_objects arg. Please test > and let me kn

Re: [RDBO] Unable to query using sub-tablename

2007-05-24 Thread John Siracusa
On 5/24/07, James Masters <[EMAIL PROTECTED]> wrote: > Query is combined viz: > prodcode => {'like' => "%shp%"} > productlocs.loccode => {'like' => "%mtg%"} > Status => {'ne' => "P"} > with_objects => productlocs > > [...] > > # "category.name" and "categories.name" would work too, since > # table

[RDBO] Unable to query using sub-tablename

2007-05-24 Thread James Masters
I'm trying to do a query against a table "products" and a subtable "productlocs" via a relationship called "sources". I've produced the following debugging info: Rose::DB - 0.734, Rose::DB::Object - 0.764, Rose::DB::Object::Manager - 0.764, Server - "bullseye" Query is combined viz: prodcode => {