Thanks! I was unaware of this property of SQLObject. All is working
well now.
On Sep 2, 6:11 am, "Diez B. Roggisch" <[EMAIL PROTECTED]>
wrote:
> seanb schrieb:
>
>
>
> > Hi all,
>
> > I'm having a problem saving data to my sqlite database from a form.
> > I've checked the data being returned by the form and it all comes out
> > fine. However if I save the data to the database, the items in my
> > database of type ForeignKey() come out as none (when viewed via
> > catwalk).
>
> > For example:
>
> > class Person (SQLObject):
> > personID = UnicodeCol(alternateID=True)
> > firstName = UnicodeCol()
> > surname = UnicodeCol()
> > email = UnicodeCol()
> > phone = UnicodeCol()
> > addressID = ForeignKey('Address')
> > companyID = ForeignKey('Company')
> > relationship = ForeignKey('Relationship')
>
> > @expose(template="rec.templates.add")
> > def save_person(self, firstName, surname, email, phone, companyID,
> > addressID, relationship, personID):
> > sp=Person(firstName=firstName, surname=surname, email=email,
> > phone=phone, companyID=Company.selectBy(id=companyID),
> > addressID=Address.selectBy(id=addressID),
> > relationship=Relationship.selectBy(id=relationship),
> > personID=personID)
> > raise redirect("/index")
>
> > I've tried passing them as objects or as numbers (the ID of the
> > foreign entity) with no success. Is there a separate method I need to
> > use to have these saved?
>
> Certainly not. But you are in naming-trouble here. Instead of calling
> things "nameID", just call them "name". That's because SO will append an
> ID-suffix itself.
>
> Then, either do
>
> address = Address.get(addressID)
> SomeObject(address=address)
>
> or
>
> SomeObject(addressID=addressID)
>
> Diez
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
