[SQLObject] Re: How do I update a many-to-many field?

[Mike K. <mrm...@co...>]

Oleg Broytmann <phd <at> mail2.phd.pp.ru> writes:

>    Do you want to replace the author? Than you don't want many-to-many
> relationship.

Oleg, can you expand on that please?  My thinking is this: as I said in the
schema, a book can have many authors, and an author can write many books, so it
sounds like a many-to-many relationship.  Yet you still need to be able to
update a book entry, to say, correct the name of an author.  Now, SQLObject
gives you the ability to add an author to a book with the automatic handling of
the many-to-many relationship table.  Apparently it does not give you automatic
handling of the many-to-many relationship table for an update operation.  So I
was looking for the correct way to handle this myself.