Begin forwarded message:
Date: Mon, 8 May 2006 19:27:45 +0200
From: Felix <[EMAIL PROTECTED]>
To: Oleg Broytmann <[EMAIL PROTECTED]>
Subject: Re: [SQLObject] Substitute fieldID for fieldName
Thanks again Oleg it works !
On Mon, 8 May 2006 17:11:47 +0400
Oleg Broytmann <[EMAIL PROTECTED]> wrote:
> On Mon, May 08, 2006 at 02:28:03PM +0200, Felix wrote:
> > Three simple tables with relations:
> >
> > class rank(SQLObject):
> > id = IntCol()
> > title = StringCol()
> > persons = MultipleJoin('person')
> >
> > class kind(SQLObject):
> > id = IntCol()
> > kindName = StringCol()
> > persons = MultipleJoin('person')
> >
> > class person(SQLObject):
> > id = IntCol()
> > name = StringCol()
> > rankID = ForeignKey('rank')
> > kindID = ForeignKey('kind')
> >
> >
> > What's the best way to get title and kindName instead rankID and kindID
> > if i do person.get(1).select() (or else)?
>
> class rank(SQLObject):
> id = IntCol()
> title = StringCol()
> persons = MultipleJoin('person', joinColumn="rank_id")
>
> class kind(SQLObject):
> id = IntCol()
> kindName = StringCol()
> persons = MultipleJoin('person', joinColumn="kind_id")
>
> class person(SQLObject):
> id = IntCol()
> name = StringCol()
> rank = ForeignKey('rank')
> kind = ForeignKey('kind')
>
> person.get(1).rank
>
> Oleg.
> --
> Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
> Programmers don't die, they just GOSUB without RETURN.
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sqlobject-discuss mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
