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

Reply via email to