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 and relationship names are also valid prefixes.
>
> I expect I'm misunderstanding something as usual. But if the documentation
> is right, then shouldn't the error message say "no foreign key or
> relationship or table named..."? i.e. the error message seems to match the
> result but not the documentation.
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 know if I'm wrong :)
-John
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
