Hi all I want to update a table named Space that have a column pages:
class Space(SQLObject): ...... pages = MultipleJoin('Page', orderBy=['type', 'name']) And there is Page class: class Page(SQLObject): ... space = ForeignKey('Space') synchronized = BoolCol(default=False) I need to update all of records' synchronized attribute to 'True' in page table where the space.id is 1. I guessed I may write the code such as: from sqlobject.sqlbuilder import Update Update(Page.sqlmeta.table, True, ..., "Space.q.id=1") But I dont know what is the third parameter, from the source code I saw template. What is template? The document of sqlobject.org does not introduce the class detail of sqlbuilder and the FAQ just have Delete. -- with kind regards ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss