Re: MySQLdb not updating rows

2006-07-01 Thread Lawrence D'Oliveiro
In article <[EMAIL PROTECTED]>, "Bowen" <[EMAIL PROTECTED]> wrote: >In article <[EMAIL PROTECTED]>, Benjamin Niemann <[EMAIL PROTECTED]> >wrote: > >>Another side note: don't build your queries using (dumb) string formatting, >>let the MySQLdb module do it for you. > >Thanks for that tip, it's a

Re: MySQLdb not updating rows

2006-06-28 Thread Bowen
Thanks for that tip, it's a simple script that I am experimenting on, planning to build a custon gui for my database. It is definately something for me to note in the future. Thanks again. -- http://mail.python.org/mailman/listinfo/python-list

Re: MySQLdb not updating rows

2006-06-28 Thread Benjamin Niemann
Bowen wrote: > import md5 > import string > import MySQLdb > > tc = raw_input("Teacher Code: ") > p = raw_input("New Password: ") > > print tc > hash = md5.new() > hash.update(p) > print p > print hash.hexdigest() > h = hash.hexdigest() > > boo = raw_input("Sure you want to update password with

Re: MySQLdb not updating rows

2006-06-28 Thread Douglas Andrade
Hello Simon,Take a look at this link: http://python.codezoo.com/pub/component/3583 May autocommit (or commit, as Fredrik pointed out) be the solution.On 28 Jun 2006 06:46:54 -0700, Bowen <[EMAIL PROTECTED] > wrote:Thanks for that, it appears it was the db.commit() that sorted itout.lesson learn

Re: MySQLdb not updating rows

2006-06-28 Thread Bowen
Thanks for that, it appears it was the db.commit() that sorted it out.lesson learnt :) -- http://mail.python.org/mailman/listinfo/python-list

Re: MySQLdb not updating rows

2006-06-28 Thread Fredrik Lundh
"Bowen" <[EMAIL PROTECTED]> wrote: > boo = raw_input("Sure you want to update password with above details? Y or N: > ") > > if boo == 'y': if you're asking for Y or N, maybe you should check for Y or N ? or better, use something like: if boo.lower() == 'y': ... or even if boo

MySQLdb not updating rows

2006-06-28 Thread Bowen
import md5 import string import MySQLdb tc = raw_input("Teacher Code: ") p = raw_input("New Password: ") print tc hash = md5.new() hash.update(p) print p print hash.hexdigest() h = hash.hexdigest() boo = raw_input("Sure you want to update password with above details? Y or N: ") if boo == 'y':