This is the method I've built in my controller:
##################
import turbogears
from turbogears import controllers

from model import HPD_HelpDesk


class Root(controllers.Root):
    @turbogears.expose(html="wiki20.templates.welcome")
    def index(self):
        results = [ticket.priority for ticket in HPD_HelpDesk.select()]
        return dict(results=results)
##################

I'm not doing anything fancy, just selecting all records, right?

But I get this error:
500 Internal error

Server got itself in trouble

Traceback (most recent call last):
  File
"c:\python24\lib\site-packages\CherryPy-2.1.1-py2.4.egg\cherrypy\_cphttptools.py",
line 271, in run
    main()
  File
"c:\python24\lib\site-packages\CherryPy-2.1.1-py2.4.egg\cherrypy\_cphttptools.py",
line 502, in main
    body = page_handler(*args, **cherrypy.request.paramMap)
  File
"c:\python24\lib\site-packages\TurboGears-0.8.8-py2.4.egg\turbogears\controllers.py",
line 124, in newfunc
    output = func(self, *args, **kw)
  File "C:\turbogears\tt_reports\tt_reports\controllers.py", line 12,
in index
    results = [ticket.priority for ticket in HPD_HelpDesk.select()]
  File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1457-py2.4.egg\sqlobject\sresults.py",
line 149, in __iter__
    return iter(list(self.lazyIter()))
  File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1457-py2.4.egg\sqlobject\sresults.py",
line 156, in lazyIter
    conn = self._getConnection()
  File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1457-py2.4.egg\sqlobject\sresults.py",
line 38, in _getConnection
    return self.ops.get('connection') or self.sourceClass._connection
  File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1457-py2.4.egg\sqlobject\dbconnection.py",
line 856, in __get__
    return self.getConnection()
  File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1457-py2.4.egg\sqlobject\dbconnection.py",
line 868, in getConnection
    raise AttributeError(
AttributeError: No connection has been defined for this thread or
process


Any ideas?

Thanks,

Don

Reply via email to