Re: [SQLObject] How to use Update

2007-05-17 Thread Jorge Godoy
ro <[EMAIL PROTECTED]> writes: > Page._connection.query(Page._connection.sqlrepr(Update(Page.sqlmeta.table, > > {"synchronized": True}, > > where=Page.q.space_id==1))) Try: Page.q.spaceID -- Jorge Godoy <[EMAIL PROTECTED]> -

Re: [SQLObject] How to use Update

2007-05-17 Thread ro
On 5/17/07, ro <[EMAIL PROTECTED]> wrote: > On 5/16/07, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > > Page._connection.query(Page._connection.sqlrepr( > > Update(Page.sqlmeta.table, {"synchronized": True}, where=Space.q.id==1) > > )) > > > > Sorry, I am trying this code now, but it does not work

Re: [SQLObject] How to use Update

2007-05-17 Thread ro
On 5/16/07, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Wed, May 16, 2007 at 08:36:00PM +0800, ro wrote: > > I need to update all of records' synchronized attribute to 'True' in > > page table where the space.id is 1. > > > > from sqlobject.sqlbuilder import Update > > Update(Page.sqlmeta.table

Re: [SQLObject] How to use Update

2007-05-16 Thread ro
On 5/16/07, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Wed, May 16, 2007 at 09:02:38PM +0800, ro wrote: > > Include the MySQL question:) > > Does my advice work? (I do not use MySQL personally so I have to rely on > patches and tests from other people.) > > Oleg. > -- Yes, it works. Thank you

Re: [SQLObject] How to use Update

2007-05-16 Thread Oleg Broytmann
On Wed, May 16, 2007 at 09:02:38PM +0800, ro wrote: > Include the MySQL question:) Does my advice work? (I do not use MySQL personally so I have to rely on patches and tests from other people.) Oleg. -- Oleg Broytmannhttp://phd.pp.ru/[EMAIL PROTECTED] P

Re: [SQLObject] How to use Update

2007-05-16 Thread ro
On 5/16/07, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Wed, May 16, 2007 at 08:58:28PM +0800, ro wrote: > > I want to learn that, which document introduce it? > > Source code ;) Want to submit documentation patches?.. > Yes, of course. Include the MySQL question:) -- with kind regards ---

Re: [SQLObject] How to use Update

2007-05-16 Thread Oleg Broytmann
On Wed, May 16, 2007 at 08:58:28PM +0800, ro wrote: > I want to learn that, which document introduce it? Source code ;) Want to submit documentation patches?.. Oleg. -- Oleg Broytmannhttp://phd.pp.ru/[EMAIL PROTECTED] Programmers don't die, they just GO

Re: [SQLObject] How to use Update

2007-05-16 Thread ro
On 5/16/07, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Wed, May 16, 2007 at 08:36:00PM +0800, ro wrote: > > I need to update all of records' synchronized attribute to 'True' in > > page table where the space.id is 1. > > > > from sqlobject.sqlbuilder import Update > > Update(Page.sqlmeta.table

Re: [SQLObject] How to use Update

2007-05-16 Thread Oleg Broytmann
On Wed, May 16, 2007 at 08:36:00PM +0800, ro wrote: > I need to update all of records' synchronized attribute to 'True' in > page table where the space.id is 1. > > from sqlobject.sqlbuilder import Update > Update(Page.sqlmeta.table, True, ..., "Space.q.id=1") Update is a low-level object, yo

[SQLObject] How to use Update

2007-05-16 Thread ro
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