[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    Re: maxdb python inserting lobs
From:       Daniel Dittmar <daniel () dittmar ! net>
Date:       2007-02-14 23:28:42
Message-ID: er05u1$5g7$1 () sea ! gmane ! org
[Download RAW message or body]

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/maxdb?unsub=sapdb-general@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]