I have met similar problem, and still don't know why...I have two py
scripts to call some model methods using raw sql UPDATE, one script
runs correctly when I use transaction, but the other doesn't. really
strange..
On 12月27日, 下午11时57分, beewee <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm using the latest svn version of django with mysql.
> Since some time I have the problem that raw UPDATE-queries I execute
> don't get really executed. Have a look at this:
>
> >>> from django.db import connection as con
> >>> cur = con.cursor()
> >>> cur.execute('SELECT topic_id FROM forum_vote')
> 6L
> >>> cur.fetchall()
>
> ((None,), (None,), (None,), (None,), (40L,), (40L,))>>> cur = con.cursor()
> >>> cur.execute('UPDATE forum_vote SET topic_id = 1')
> 6L
> >>> cur.close()
> >>> cur = con.cursor()
> >>> cur.execute('SELECT topic_id FROM forum_vote')
> 6L
> >>> cur.fetchall()
>
> ((1L,), (1L,), (1L,), (1L,), (1L,), (1L,))
>
> Setting topic_id to "1" everywhere seems to have worked.
> But when restarting the shell, the change is gone:
>
> >>> from django.db import connection as con
> >>> cur = con.cursor()
> >>> cur.execute('SELECT topic_id FROM forum_vote')
> 6L
> >>> cur.fetchall()
>
> ((None,), (None,), (None,), (None,), (40L,), (40L,))
>
> What can I do to solve this problem? Is this a bug?
>
> Thank you for your help,
>
> Benjamin Wiegand
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
