jamestmcneill-python at yahoo.co.uk
jamestmcneill-python at yahoo.co.uk
Tue Sep 13 10:37:32 EDT 2005
Good afternoon. I wonder if someone may be able to help me get to the starting line with mod_python? I'm trying to use PythonImport to create a database connection which I can use for subsequent requests, and I haven't been able to figure out how. Here's what I'm putting in httpd.conf: PythonInterpreter maininterpreter PythonImport mpglobals maininterpreter <Directory "C:\Program Files\Apache Group\Apache2\htdocs\moddy"> AddHandler mod_python .py PythonHandler mptest PythonDebug On </Directory> mpglobals.py is in the "C:\Program Files\Apache Group\Apache2\htdocs\moddy" folder, and an entry in c:\python23\mp.pth adds this to sys.path. mpglobals.py attempts to load a database connection as global: import kinterbasdb as fbd con = fbd.connect(dsn='localhost:C:\Program Files\Firebird\Firebird_1_5\examples\employee.fdb', user='sysdba', password='masterkey') cur = con.cursor() Finally, the default python handler mptest.py tries to use the connection: def handler(req): cur.execute('select * from EMPLOYEE order by LAST_NAME') . . . . return apache.OK This throws up an error: File "C:/Program Files/Apache Group/Apache2/htdocs/moddy/\mptest.py", line 8, in handler cur.execute('select * from EMPLOYEE order by LAST_NAME') NameError: global name 'cur' is not defined Am I anywhere near going about this the right way? Can someone please draw me a diagram? Regards, Jim ++++++++++++++++++++++++++++++++++++++++++++++++++ + If you've got a good excuse - don't use it + ++++++++++++++++++++++++++++++++++++++++++++++++++)
|