Re: [SQLObject] Selecting a single column

2010-07-12 Thread Oleg Broytman
On Mon, Jul 12, 2010 at 11:12:54PM +, Mark wrote: > some of > my tables aren't really objects as much as linking tables. > In this case we have a User who has friends so I added a > Friends class (userid,friendid) It seems you want ForeignKey/MultipleJoin/RelatedJoin. Oleg. -- Oleg

Re: [SQLObject] Selecting a single column

2010-07-12 Thread Frank Wagner
2010/7/13 Daniel: >> I seem to be uncomfortable using SQLObject because some of >> my tables aren't really objects as much as linking tables. >> In this case we have a User who has friends so I added a >> Friends class (userid,friendid) which isn't really an >> object in my mind. i think youre thi

Re: [SQLObject] Selecting a single column

2010-07-12 Thread Daniel Fetchinson
> I need a single column of the table in list format format > based ie select col1 where foo. Can I do this? See http://www.mail-archive.com/sqlobject-discuss@lists.sourceforge.net/msg04736.html > Can I write my own sql? Whats the most efficient way to do this? See http://sqlobject.org/SQLBuild

[SQLObject] Selecting a single column

2010-07-12 Thread Mark
I need a single column of the table in list format format based ie select col1 where foo. Can I do this? Can I write my own sql? Whats the most efficient way to do this? I seem to be uncomfortable using SQLObject because some of my tables aren't really objects as much as linking tables. In this