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