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.
> The error is
>
> OperationalError: (1054, "Unknown column 'space.id' in 'where clause'")
>
> I think maybe I need use the column in Page class, so I change the code :
>
> Page._connection.query(Page._connection.sqlrepr(Update(Page.sqlmeta.table,
>
> {"synchronized": True},
>
> where=Page.q.space_id==1)))
>
> And the error change to:
> AttributeError: Page instance has no attribute 'space_id'
>
> If I write Page.q.space, the error is
> AttributeError: Page instance has no attribute 'space'
>
> But I am sure there is space in Page class
I think I have got the correct column by
print Page.sqlmeta.columns
I dont know why the columns is different with that I wrote in Page
class and the true column in database.
--
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
