Re: maxdb python inserting lobs

2007-02-14 Thread Daniel Dittmar
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" w

Re: maxdb python inserting lobs

2007-02-14 Thread Luca Calderano
- Original Message - From: "Daniel Dittmar" <[EMAIL PROTECTED]> To: Sent: Wednesday, February 14, 2007 1:13 AM Subject: Re: maxdb python inserting lobs Luca Calderano wrote: Can someone explain me how to insert data into lob fields using the maxdb python interface? Use prepared sta

RE: backup check impossible

2007-02-14 Thread Ralf Löwa
Hello, an upgrade of MaxDB from version 7.6.00.12 to 7.6.00.36 solved the problem. Now we can check the networker backups. Best regards, Ralf ___ Telefonate ohne weitere Kosten vom PC zum PC: http://messenger.yahoo.de

Deleted Record

2007-02-14 Thread Daniel Castro
Hi, I need to know who (the user) deleted some records last week in the database. I know the record primary key and the time (between 9:00 and 9:30) and the day this record was deleted. Can you help me? Best Regards, -- Daniel Castro - דניאל MSN: [EMAIL PROTECTED] Skype: danielti2005 ICQ : 3167

AW: "order by" problem with 7.6.00.34

2007-02-14 Thread Hübschen , Peter
> -Ursprüngliche Nachricht- > Von: Robert Klemme [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 14. Februar 2007 11:02 > An: Hübschen, Peter > Cc: maxdb@lists.mysql.com > Betreff: Re: "order by" problem with 7.6.00.34 > > 2007/2/14, Hübschen, Peter <[EMAIL PROTECTED]>: > > Which DB param

Re: "order by" problem with 7.6.00.34

2007-02-14 Thread Robert Klemme
2007/2/14, Hübschen, Peter <[EMAIL PROTECTED]>: Which DB parameter did you change? IIRC it was OPTIMIZE_OPERATOR_JOIN but there are some others like JOIN_SEARCH_LEVEL. See documentation or even better check your DB instance. robert -- Have a look: http://www.flickr.com/photos/fussel-foto/ --

Re: Problem with DATALOAD command in LONG values case

2007-02-14 Thread Schildberg, Steffen
Hi all, the problem is found - the Loader computes the offset of the longfile wrong if this file is encoded as UCS2. A workaround would be to change the first row of the data file as follows: Change "1","2","3-42" to "1","2","1-40" and the Loader will insert the Long values correctly. We'll c

AW: Re: "order by" problem with 7.6.00.34

2007-02-14 Thread Hübschen , Peter
> -Ursprüngliche Nachricht- > Von: Becker, Holger [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 14. Februar 2007 08:19 > An: Hübschen, Peter > Cc: maxdb@lists.mysql.com; Robert Klemme > Betreff: RE: [LIKELY JUNK]Re: "order by" problem with 7.6.00.34 > > > -Original Message- > >

Re: Please help me with unicode problem

2007-02-14 Thread Daniel Dittmar
이민우 wrote: > I use python interface module, and I use that very well. > But I have a problem when I excute insert command. > There are some Korean in that query sentence. > After I excuted that command, the characters was not shown normaly. > I tried many times to find what's the problem. > I concl

Re: maxdb python inserting lobs

2007-02-14 Thread Daniel Dittmar
Luca Calderano wrote: Can someone explain me how to insert data into lob fields using the maxdb python interface? Use prepared statements (http://dev.mysql.com/doc/maxdb/en/20/512a7c5647e64a863683cc6333617b/frameset.htm) As the parameter passed to the execute method, you can use either - a