global name is not defined

[Looney, James B]

Looks like you forgot to import EMR_globals, EMR_main, etc. 

> -----Original Message-----
> From: python-list-bounces+james.b.looney=lmco.com at python.org 
> [mailto:python-list-bounces+james.b.looney=lmco.com at python.org
> ] On Behalf Of barronmo
> Sent: Tuesday, November 06, 2007 2:57 PM
> To: python-list at python.org
> Subject: global name is not defined
> 
> I'm getting an error msg I don't understand, "global name EMR_globals
> is not defined", and could use some help.
> 
> I've separated the application I'm building into several modules.  One
> of the modules holds variables I need to pass from one module to
> another and is called 'EMR_globals'.  Several other modules hold
> functions or user menus and then 'EMR_main' controls the initial user
> interaction.  I'm using MySQL to hold the data.
> 
> The initial connection to the database is done by 'EMR_main'.
> Functions then define and close a cursor for various queries.  The
> connection variable, 'conn', is defined 'conn = "" ' in EMR_globals
> and then used in EMR_main.  Unfortunately when a module.function
> attempts to use it I get the error msg.
> 
> Here is the source of the error, module 'name_lookup':
> 
> def name_find(namefrag):
> 
>      cursor = EMR_globals.conn.cursor(MySQLdb.cursors.DictCursor)
>      cursor.execute("SELECT patient_ID, firstname, lastname FROM
> demographics WHERE lastname LIKE '%s%%'" % (namefrag))
> 
>      results = cursor.fetchall()
> 
>      for index, row in enumerate(results):
>           print "%d %s   %s %s" % (index, row["patient_ID"],
> row["firstname"], row["lastname"])
> 
>      indx = int(raw_input("Select the record you want: "))
>      results_list = list(results)
>      a = str(results_list[indx]['patient_ID'])
>      print 'You have chosen patient ID # ' + a
> 
>      cursor.execute("SELECT * FROM demographics WHERE patient_ID = %s"
> % (a,))
>      selected_pt = cursor.fetchall()
> # if this query returns more than one record the following code will
> fail I think
>      print menus.menu_demographics(selected_pt['firstname'],
> 	selected_pt['lastname'],
> 	selected_pt['address'],
> 	selected_pt['city'],
> 	selected_pt['state'],
> 	selected_pt['zipcode'],
> 	selected_pt['phonenumber'])
>      print menus.menu_pt_record
> 
>      cursor.close()
> 
> 
> Thanks for any help.   Mike
> 
> -- 
> http://mail.python.org/mailman/listinfo/python-list
>