[Zope-DB] cannot commit and nothing is written
Florian Schuler
florian.schuler@braunconsulting.de
Mon, 15 Oct 2001 10:04:28 +0200
Hello List,
I have a problem using pycong-0.99-5.
I want to insert a line into a table from a python script.=20
I do:=20
-->
c1.execute("insert into %s values
(%d,%d,%d,'%s','%s','%s','%s','%s','%s',%d);"=20
% (Mail_TABLE,
int(MailID),
int(ListID),
int(ListEbene),
str(Absender_Adresse),
str(Absender_Name),
str(EMailDaten_betreff),
str(datum),
str(uhrzeit),
str(EMailDaten_inhalt),
int(BezugMailID)))
c1.commit()
<--
It seems to work. The Debug message of pycong says:
[15758] psyco_curs_execute(): operation =3D >insert into mailingliste
values
(11,10,0,'fschuler@braunconsulting.de','fschuler@braunconsulting.de','N/=
A','11.10.2001','16:21:46','Das ist eine TestMassage mit List ID im
header',1);<
[15758] psyco_curs_execute(): operation->refcnt =3D 1
[15758] _psyco_curs_execute(): connection at 0x81072b0 OK
[15758] _psyco_curs_execute(): query =3D >insert into mailingliste =
values
(11,10,0,'fschuler@braunconsulting.de','fschuler@braunconsulting.de','N/=
A','11.10.2001','16:21:46','Das ist eine TestMassage mit List ID im
header',1);<
[15758] _psyco_curs_execute(): query executed
[15758] _psyco_curs_execute(): command returned OK (no tuples)
Traceback (innermost last):
File "pop.py", line 202, in ?
c1.commit()
psycopg.Error: serialized connection: cannot commit on this cursor
But the commit() doesn=B4t work and nothing is written into my table.=20
Does somebody of you know an awnser ?
Thanks in advance=20
Florian Schuler