I feel stupid again. That's the second time I've had that problem.
I think I'm definitely going to put the effort into moving to
SQAlchemy. The 'magic' in SQLObject keeps tripping me up.
Thanks for your help.
Ed
On 6/1/06, Sean De La Torre <[EMAIL PROTECTED]> wrote:
> Try changing your multiple join to this:
>
> user_permissions = MultipleJoin('UserPagePermissi
> on', joinColumn='page_id')
>
>
> On 6/1/06, Ed Singleton <[EMAIL PROTECTED]> wrote:
> >
> > I want to be able to assign a user a permission on a page. I assumed
> > the best way to do this would be a related join using all three
> > tables.
> >
> > What I've got so far is:
> >
> > class Page(SQLObject):
> > title = UnicodeCol(length=64)
> > body = UnicodeCol(default=None)
> > user_permissions = MultipleJoin('UserPagePermission',
> joinColumn='page')
> >
> > class UserPagePermission(SQLObject):
> > user = ForeignKey('User')
> > permission = ForeignKey('Permission')
> > page = ForeignKey('Page')
> >
> > That's using the default TG Users, Groups and Permissions.
> >
> > If I try and access apage.user_permissions I get the error:
> >
> > OperationalError: (1054, "Unknown column 'page' in 'where clause'")
> >
> > Does anyone have any advice on this?
> >
> > Thanks
> >
> > Ed
> >
> >
> >
> >
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
