id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
3875	sql syntax error on postgres	mixedpuppy	JoshuaH	patch to fix:\r\n\r\nIndex: /Users/shanec/svn/users/shanec/tforge/build/plugins/roadmaphoursplugin/roadmaphours/roadmaphours.py\r\n===================================================================\r\n--- roadmaphours.py_(revision 4430)\r\n+++ roadmaphours.py_(working copy)\r\n@@ -63,8 +63,8 @@\r\n         if total_cnt:\r\n             cursor = self.env.get_db_cnx().cursor()\r\n             str_ids = [str(x) for x in sorted(ticket_ids)]\r\n-_    cursor.execute("SELECT status, est.value as 'Est', "\r\n-___   "act.value as 'Act' "\r\n+_    cursor.execute("SELECT status, est.value as Est, "\r\n+___   "act.value as Act "\r\n ___   "FROM ticket t "\r\n ___   "LEFT OUTER JOIN ticket_custom est ON "\r\n ___   "  (t.id=est.ticket AND est.name='estimatedhours') "\r\n\r\n	defect	closed	normal	RoadmapHoursPlugin	normal	fixed			0.11