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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
