Re: question about deleting records from mysql

2005-07-27 Thread Cantankerous Old Git
nephish wrote: > Man, thanks for the link. and the tip. i am testing > the db.commit() and printing the doc right now. > thanks again. If it's any help, using cursor.execute("set autocommit = 1") before doing anything else works nicely unless you actually need transactions. The Cog -- ht

Re: question about deleting records from mysql

2005-07-27 Thread nephish
Man, thanks for the link. and the tip. i am testing the db.commit() and printing the doc right now. thanks again. On 07/27/2005 07:43:24 AM, Rowdy wrote: > [EMAIL PROTECTED] wrote: >> ok. did this >> >> > cursor.execute("DELETE FROM table WHERE autoinc > 1000") >> >> 245L >> > cursor.

Re: question about deleting records from mysql

2005-07-27 Thread Rowdy
[EMAIL PROTECTED] wrote: > ok. did this > > cursor.execute("DELETE FROM table WHERE autoinc > 1000") > > 245L > cursor.commit() > > > i got an AttributeError 'Cursor' object has no attribute 'commit' > > hmm. what should i do now? > the stuff about writing a lightweight layer between

Re: question about deleting records from mysql

2005-07-27 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2005-07-27 05:12:46 -0700: > ok. did this > > >>> cursor.execute("DELETE FROM table WHERE autoinc > 1000") > 245L > >>> cursor.commit() > > i got an AttributeError 'Cursor' object has no attribute 'commit' > > hmm. what should i do now? RTFM, e. g. here: http://c

Re: question about deleting records from mysql

2005-07-27 Thread nephish
ok. did this >>> cursor.execute("DELETE FROM table WHERE autoinc > 1000") 245L >>> cursor.commit() i got an AttributeError 'Cursor' object has no attribute 'commit' hmm. what should i do now? the stuff about writing a lightweight layer between the dbapi and the program shot right over my head. s

Re: question about deleting records from mysql

2005-07-27 Thread Mage
nephish wrote: >Simon Brunning wrote: > > > >>On 27 Jul 2005 04:29:33 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >> >> >> >> >>>Hey there, >>>sorry , second question in as many days. >>>i am trying to do some stuff with MySQLdb and the thing is, i can >>>select records and such, bu

Re: question about deleting records from mysql

2005-07-27 Thread nephish
Simon Brunning wrote: >On 27 Jul 2005 04:29:33 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > >>Hey there, >>sorry , second question in as many days. >>i am trying to do some stuff with MySQLdb and the thing is, i can >>select records and such, but when i try to delete them, they dont >

Re: question about deleting records from mysql

2005-07-27 Thread Simon Brunning
On 27 Jul 2005 04:29:33 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hey there, > sorry , second question in as many days. > i am trying to do some stuff with MySQLdb and the thing is, i can > select records and such, but when i try to delete them, they dont > really go away. A fiver says

question about deleting records from mysql

2005-07-27 Thread nephish
Hey there, sorry , second question in as many days. i am trying to do some stuff with MySQLdb and the thing is, i can select records and such, but when i try to delete them, they dont really go away. like this >>> cursor.execute("DELETE FROM table WHERE autoinc > 1000") 240L >>> cursor.execute("S