It works because a query can be any valid SQL statement. stus[0].id a positive number this it is a valid SQL statement, passed verbatim to the DB in the WHERE condition, and interpreted as True.
Massimo On Dec 31 2008, 4:57 pm, "[email protected]" <[email protected]> wrote: > Nevermind. This was the problem: > > I had this in my page: > > {{form=t2.update(db.student,stus[0].id)}} > > and I changed it to: > > {{form=t2.update(db.student,db.student.id==stus[0].id)}} > > and now it works fine :) > > The second makes more sense - odd the first one works with sqlite. > > -wj > > On Dec 31, 3:43 pm, "Wes James" <[email protected]> wrote: > > > I have been moving some data from sqlite to postgres. The first thing > > I noticed was on csv export my boolean fields have True/False in the > > field data. I didn't realize this until I tried to import these in to > > postgres when the field is char(1) for boolean. I changed all the > > True/False to T/F in the data and imported it. But now I'm getting > > this error when trying to view a page: > > > File "applications/plugin_t2/modules/t2.py", line 402, in update > > rows=table._db(query).select(table.ALL,limitby=(0,1)) > > File "gluon/sql.py", line 1245, in select > > File "gluon/sql.py", line 1241, in response > > File "gluon/sql.py", line 490, in <lambda> > > ProgrammingError: argument of WHERE must be type boolean, not type integer > > > It looks like postgres has type boolean: --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" 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 -~----------~----~----~----~------~----~------~--~---
