Problem with global

Florian Lindner Florian.Lindner at xgm.de
Fri Oct 12 14:50:24 EDT 2007


Hello,
I have a little problem with the global statement.

def executeSQL(sql, *args):
    try:
        import pdb; pdb.set_trace()
        cursor = db.cursor()  # db is <type 'NoneType'>.
        [...]
    except:
        print "Problem contacting MySQL database. Please contact root."
        sys.exit(-1) 


db  = None # Global Variable for DB connection
    
def main():
    [...]    
    global db
    db = MySQLdb.connect(...)
    [...]
    executeSQL(sql, args)


Why isn't the global variable db not written in main() to be a mysql
connection and still none type in executeSQL?

Thanks,

Florian



More information about the Python-list mailing list