Re: [SQLObject] ViewSQLObject ID's

[Petr J. <pet...@tp...>]

>
> Obviously, if you only have many-to-one relationship (from left to
> right) you can just use the ID of the left hand table.  AFAICS that
> must be your case.  My problem is that the join involves two many-to-many
> relationships, so I cannot even use the ID's of the relation table.
>

Hmmm... anyway, what about to try to construct the view (with not unique
IDs as a result) on the server side and let the SQLObject "chew" this view
"table". I think it worth to try it. But I am sure Oleg is reading this and
gives his comments about the issue.

>
> > I did not find solution, how to solve above mentioned SELECT using the
> > SQLObject. Even using raw SELECT.
> > I mean something like: result = con.queryAllDescription("rawSqlQuerry").
> > Because of that I am using views and it works.
>
> As far as I can see, you could do the same with the ViewSQLObject class.
>

Did not think about this (I do not know the ViewSQLObject class). My
feeling is I do not need more CPU load on the client side (which IMHO
ViewSQLObject is).

>
Regards

Petr