If I put DAL and table definition in db.py all is Ok and sql.log
report:
CREATE TABLE secretnum(
id SERIAL PRIMARY KEY,
primocod VARCHAR(8),
secondocod VARCHAR(5),
terzocod VARCHAR(5),
username VARCHAR(20),
attivo CHAR(1)
);
success!
If I put DAL and table definition in plugin_secretnum.py in models I
have error:
row = db(db.secretnum.primocod == primocod).select()
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
.......and sql.log have no new message.
On 18 Nov, 21:01, mdipierro <[email protected]> wrote:
> what is in sql.log?
>
> On Nov 18, 10:54 am, leone <[email protected]> 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 [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
-~----------~----~----~----~------~----~------~--~---
