Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#164 Error when editing employee with alphanumeric employee ID

v2.0
closed-fixed
5
2007-12-19
2007-12-19
Seth Remington
No

sndcs2_web/dcs_edit_employees/edit_employee.py

Traceback (most recent call last):
File "/home/sremington/Desktop/Webware-0.9.3/WebKit/Application.py", line 628, in runTransaction [edit]
self.runTransactionViaServlet(servlet, trans)
File "/home/sremington/Desktop/Webware-0.9.3/WebKit/Application.py", line 696, in runTransactionViaServlet [edit]
servlet.runTransaction(trans)
File "/home/sremington/Desktop/Webware-0.9.3/WebKit/Servlet.py", line 59, in runTransaction [edit]
trans.respond()
File "/home/sremington/Desktop/Webware-0.9.3/WebKit/Transaction.py", line 140, in respond [edit]
self._servlet.respond(self)
File "/home/sremington/Desktop/Webware-0.9.3/WebKit/HTTPServlet.py", line 66, in respond [edit]
method(trans)
File "/home/sremington/Desktop/Webware-0.9.3/WebKit/HTTPContent.py", line 64, in respondToGet [edit]
self._respond(transaction)
File "/home/sremington/Desktop/Webware-0.9.3/WebKit/HTTPContent.py", line 106, in _respond [edit]
self.defaultAction()
File "/home/sremington/Desktop/Webware-0.9.3/WebKit/Page.py", line 30, in defaultAction [edit]
self.writeHTML()
File "/home/sremington/Desktop/Webware-0.9.3/WebKit/Page.py", line 90, in writeHTML [edit]
self.writeBody()
File "/usr/share/sndcs/web/lib/SitePage.py", line 457, in writeBody [edit]
Page.writeBody(self)
File "/home/sremington/Desktop/Webware-0.9.3/WebKit/Page.py", line 205, in writeBody [edit]
self.writeBodyParts()
File "/home/sremington/Desktop/Webware-0.9.3/WebKit/Page.py", line 224, in writeBodyParts [edit]
self.writeContent()
File "/usr/share/sndcs/web/lib/SitePage.py", line 449, in writeContent [edit]
self.writeLocalContent()
File "sndcs2_web/dcs_edit_employees/edit_employee.py", line 383, in writeLocalContent [edit]
for boss in EmployeeFactory().searchEmployee("WHERE empId<>%s ORDER BY lastName,firstName" % empId): #Display active employees/supervisors
File "/usr/lib/python2.5/site-packages/sndcs/EmployeeFactory.py", line 52, in searchEmployee [edit]
return store.fetchObjectsOfClass(Employee, clauses)
File "MiddleKit/Run/SQLObjectStore.py", line 355, in fetchObjectsOfClass [edit]
File "MiddleKit/Run/SQLObjectStore.py", line 412, in executeSQL [edit]
File "MiddleKit/Run/MySQLObjectStore.py", line 56, in _executeSQL [edit]
File "/var/lib/python-support/python2.5/MySQLdb/cursors.py", line 166, in execute [edit]
self.errorhandler(self, exc, value)
File "/var/lib/python-support/python2.5/MySQLdb/connections.py", line 35, in defaulterrorhandler [edit]
raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'joeblow' in 'where clause'"

Discussion

  • Seth Remington
    Seth Remington
    2007-12-19

    Logged In: YES
    user_id=667337
    Originator: YES

    Fixed in CVS

     
  • Seth Remington
    Seth Remington
    2007-12-19

    • status: open --> closed-fixed