Re: MySQLdb trouble

2006-05-11 Thread Nicolay A. Vasiliev
Hi! > Number two suggestion: try committing the transaction (autocommit > might not be enabled in your environment). > commit() - is what I need :) Thank you very much! -- http://mail.python.org/mailman/listinfo/python-list

Re: MySQLdb trouble

2006-05-10 Thread Nicolay A. Vasiliev
Hi! I use the DB connection from many application modules. In fact, I test some technic hardly on the local machine. When I get coming result I upload the script to the web server. I have 2 functions: connect_db and loc_connect_db. First contains the remote server login data, second - local se

Re: MySQLdb trouble

2006-05-10 Thread Thomas Bartkus
"John Salerno" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Thomas Bartkus wrote: > > > 1) His code body will be less likely to cause migrane headaches when he > > tries to read and interpret what he did a year from now. If you are trying > > to figure out what is going on with t

Re: MySQLdb trouble

2006-05-10 Thread John Salerno
Thomas Bartkus wrote: > 1) His code body will be less likely to cause migrane headaches when he > tries to read and interpret what he did a year from now. If you are trying > to figure out what is going on with the logic, user names and passwords can > be so much chaff your brain needs to wade th

Re: MySQLdb trouble

2006-05-10 Thread Thomas Bartkus
"John Salerno" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Nicolay A. Vasiliev wrote: > > > def loc_connect_db(): > >""" > >The DB connection subroutine > >""" > >db = MySQLdb.connect(host = "localhost", > >user = "root", > >

Re: MySQLdb trouble

2006-05-10 Thread John Salerno
Nicolay A. Vasiliev wrote: > def loc_connect_db(): >""" >The DB connection subroutine >""" >db = MySQLdb.connect(host = "localhost", >user = "root", >passwd="mysql", >db="some_db") >return db Hi. Sorry I c

MySQLdb trouble

2006-05-10 Thread Nicolay A. Vasiliev
Hello there! I got some trouble trying to insert data into the database with MySQLdb module. I have such code: from MySQLdb import * def loc_connect_db(): """ The DB connection subroutine """ db = MySQLdb.connect(host = "localhost", user = "root",