sqlobject-discuss

[SQLObject] Custom query results?

[Pгoмᴇтнᴇυs 0. <pro...@gm...>]

Hi all,

I was wondering if it was possible to attach columns from another table (a
many-to-many relationship table) to results returned from er-- that other
table.

To use an example from the SQLObject documentation:
http://sqlobject.org/FAQ.html#how-can-i-define-my-own-intermediate-table-in-my-many-to-many-relationship

Is it possible to have User.roles return the Role information along with
'active' from the UserRoles class? How might this be done?

Thanks again!

Re: [SQLObject] Custom query results?

[Oleg B. <ph...@ph...>]

On Wed, May 11, 2011 at 01:14:22PM -0600, Pгoм???тн?????s 0x01 wrote:
> I was wondering if it was possible to attach columns from another table

   Not with high-level API (classes/instances); see

http://sqlobject.org/FAQ.html#how-can-i-do-a-left-join

   See also sqlbuilder.Select:

http://sqlobject.org/SQLBuilder.html#select

   but it's lower-level API.

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.