Grrr.
I can't uderstand. I have code that runs in sqlite bat non in
postgresql.
Apparently it is very simple.
Where is my error??

db.define_table('secretnum',
                Field('primocod','string', length=8),
                Field('secondocod','string', length=5),
                Field('terzocod','string', length=5),
                Field('username','string', length=20),
                Field('attivo','boolean', default=True),
            )
row = db(db.secretnum.primocod == '12345678').select()

Error:
File "/home/eugenio/web2py/web2py/gluon/sql.py", line 2901, in select
    rows = response(query)
  File "/home/eugenio/web2py/web2py/gluon/sql.py", line 2896, in
response
    db._execute(query)
  File "/home/eugenio/web2py/web2py/gluon/sql.py", line 909, in
<lambda>
    self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
InternalError: current transaction is aborted, commands ignored until
end of transaction block
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to