Thanks Kevin, I will look into SQLAlchemy.
Unfortunately, b.ne_ems_id.ems_name does not work I just get the
following:
Traceback (most recent call last):
File "<console>", line 1, in ?
AttributeError: 'int' object has no attribute 'ems_name'
If it matters, I am using pymssql
On 2 Jul, 19:27, "Kevin Horn" <[EMAIL PROTECTED]> wrote:
> On Wed, Jul 2, 2008 at 12:21 PM, jrpfinch <[EMAIL PROTECTED]> wrote:
>
> > Hi I'm new at TurboGears and am getting slightly confused/lost by the
> > SQLObject docs.
>
> > I would be grateful if somebody could explain what the easiest way to
> > get the ems_name of a record in Ne_live is.
>
> > b=Ne_live.get(4)
> > b.Ems_live.ems_name ?????????
> > Traceback (most recent call last):
> > File "<console>", line 1, in ?
> > AttributeError: 'Ne_live' object has no attribute 'Ems_live'
> > c.ne_ems_id.ems_name ?????
> > Traceback (most recent call last):
> > File "<console>", line 1, in ?
> > AttributeError: 'int' object has no attribute 'ems_name'
>
> > class Ems_live(SQLObject):
> > class sqlmeta:
> > idName = "ems_id"
> > ems_name = StringCol()
> > ems_sm_time = DateTimeCol()
> > ems_sm_code = IntCol()
>
> > class Ne_live(SQLObject):
> > class sqlmeta:
> > idName = "ne_id"
> > ne_ems_id = ForeignKey("Ems_live")
> > ne_name = StringCol()
>
> > Many thanks
>
> > Jon
>
> First, if you're just getting started with TG, you might really want to
> consider using SQLAlchemy rather than SQLObject. I totally understand if
> you want to take the learning curve in small doses, though.
>
> Second, I think (based on a hazy memory of SQLObject), that you want
> something like:
>
> b=Ne_live.get(4)
> b.ne_ems_id.ems_name
>
> You might want to check out this tutorial for more
> info:http://exogen.case.edu/turbogears.html
>
> It's a little outdated, but it should give you an idea.
>
> Good luck!
>
> Kevin Horn
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
