Re: maxdb python inserting lobs

Daniel Dittmar <[email protected]>
Newsgroups gmane.comp.db.maxdb
Message-ID <[email protected]>
Luca Calderano wrote:
>    insert = req.session['cnn'].prepare("""INSERT INTO 
> "GestionePratiche"."PrevisioniNote" VALUES ( DEFAULT , %s, ?, '%s', 
> '%s', DEFAULT ,  DEFAULT ,  DEFAULT )
> """ % (req.session['CL'], dataRif, dataReg))
>    insert.execute([str(note)])
>    return "Dati inviati al server"
> 
> when I shoot this function I don't receive any error, but the table 
> doesn't contain the new values

You need to call session.commit () to make any changes permanent. 
(Unless this is done by your connection pool automatically)

Daniel


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.