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
-~----------~----~----~----~------~----~------~--~---
