what is in sql.log?
On Nov 18, 10:54 am, leone <handja...@gmail.com> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---