title: mod_python and getting the QUERY_STRING using env_vars()
body: <p>I am having some problems with some code, trying to get the QUERY_STRING but when I look at the errors in the console its coming back with an internal Error 500 which seems to be caused by the line <code>getReqStr = env_vars['QUERY_STRING']</code></p>
  
  <p>Anyone any ideas how to fix this please? </p>
  
  <pre><code>import MySQLdb
  import cgi, cgitb
  from urlparse import urlparse
  
  def index(req):
  
      req.add_common_vars()
      env_vars = req.subprocess_env
      getReqStr = env_vars['QUERY_STRING']           
      getReqArr = getReqStr.split('&amp;')               
      getReqDict = {}
  
      for item in getReqArr:                          
         tempArr = item.split('=')                    
         getReqDict[tempArr[0]] = tempArr[1]
   
      dtbox = getReqDict['dt']
      tmbox = getReqDict['tm']
  
      con = MySQLdb.connect('localhost', 'root', '', 'mydb')
  
      with con:
          cur = con.cursor(MySQLdb.cursors.DictCursor)
          st = "SELECT tmp, watts FROM currentcost WHERE dt ='" + dtbox + "' and tm like '" + tmbox + "%'"
          cur.execute (s)
          rows = cur.fetchall()
  
          x=""
          y=""
          for row in rows:
              x=x+row["watts"]+","
              y=y+row["tmp"]+","
  
      x="data:["+x+"]"
      y="data:["+y+"]"
  
      con.close()
  
      req.write(st)
  </code></pre>
  
  <p>EDIT.</p>
  
  <p>Here is the response I'm getting back through Chrome's console:</p>
  
  <p>MOD_PYTHON ERRORProcessId:      3424Interpreter:    '127.0.1.1'ServerName:     '127.0.1.1'DocumentRoot:   '/var/www'URI:            '/currentcost.py'Location:       NoneDirectory:      '/var/www/'Filename:       '/var/www/currentcost.py'PathInfo:       ''Phase:          'PythonHandler'Handler:        'mod_python.publisher'Traceback (most recent call last):  File "/usr/lib/python2.7/dist-packages/mod_python/importer.py", line 1537, in HandlerDispatch    default=default_handler, arg=req, silent=hlist.silent)  File "/usr/lib/python2.7/dist-packages/mod_python/importer.py", line 1229, in _process_target    result = _execute_target(config, req, object, arg)  File "/usr/lib/python2.7/dist-packages/mod_python/importer.py", line 1128, in _execute_target    result = object(arg)  File "/usr/lib/python2.7/dist-packages/mod_python/publisher.py", line 204, in handler    module = page_cache[req]  File "/usr/lib/python2.7/dist-packages/mod_python/importer.py", line 1059, in <strong>getitem</strong>    return import_module(req.filename)  File "/usr/lib/python2.7/dist-packages/mod_python/importer.py", line 296, in import_module    log, import_path)  File "/usr/lib/python2.7/dist-packages/mod_python/importer.py", line 680, in import_module    execfile(file, module.<strong>dict</strong>)  File "/var/www/currentcost.py", line 17    getReqStr = env_vars['QUERY_STRING']           ' the url after the ?                                                                       ^SyntaxError: EOL while scanning string literalMODULE CACHE DETAILSAccessed:       Thu Sep 26 09:18:30 2013Generation:     0_mp_545c0d0056a74a40503ad1da7dbb26e2 {  FileName:     '/var/www/currentcost.py'  Instance:     1 [IMPORT]  Generation:   0 [ERROR]  Modified:     Thu Sep 26 09:10:57 2013}</p>