On Thu, Sep 17, 2009 at 10:55 AM, Thadeus Burgess <[email protected]>wrote:
> I have tried this many different ways and have yet to be successful. > > Making a Many-to-many query is easy, and displaying the data is easy, but > how do I use SQLFORM with a M-M relationship!? > Not sure what you are asking - if you have a m-2-m table, it is nothing but a referential table. If you update one table (e.g. book section 6.9, p.190 - db.person), then ... give an example of what you want to do? If you want to have a form to enter a person (owner) name, for example, and let them list the dogs they own, this is two forms (logically) and a controller will fill out the relationship table (not the form). But maybe I am not quessing at your question correctly? - Yarko > -Thadeus > > > > > > On Tue, Sep 15, 2009 at 12:08 PM, Thadeus Burgess > <[email protected]>wrote: > >> How would you go about using SQLFORM on a database object that has a many >> to many relationship. >> >> My current model displays correctly, however it errors on submit. >> >> Thanks for the help! >> >> """ >> Table definition >> """ >> db.define_table("room", >> Field("name", "string"), >> Field("size", "integer")) >> >> """ >> Table definition >> >> db.table.field.requires=IS_IN_DB(db,'othertable.id >> ','%(otherfield)',multiple=True) >> """ >> db.define_table("study", >> Field("number", "string"), >> Field("rooms", db.room, requires=IS_IN_DB(db, 'room.id', 'room.name', >> multiple=True)), >> ) >> >> TypeError: int() argument must be a string or a number, not 'list' >> >> >> -Thadeus >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" 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/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
