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
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.
[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
# [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
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
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
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
>
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
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