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:

Index: /Users/shanec/svn/users/shanec/tforge/build/plugins/roadmaphoursplugin/roadmaphours/roadmaphours.py
===================================================================
--- roadmaphours.py	(revision 4430)
+++ roadmaphours.py	(working copy)
@@ -63,8 +63,8 @@
         if total_cnt:
             cursor = self.env.get_db_cnx().cursor()
             str_ids = [str(x) for x in sorted(ticket_ids)]
-	    cursor.execute(""SELECT status, est.value as 'Est', ""
-			   ""act.value as 'Act' ""
+	    cursor.execute(""SELECT status, est.value as Est, ""
+			   ""act.value as Act ""
 			   ""FROM ticket t ""
 			   ""LEFT OUTER JOIN ticket_custom est ON ""
 			   ""  (t.id=est.ticket AND est.name='estimatedhours') ""

",defect,closed,normal,RoadmapHoursPlugin,normal,fixed,,,0.11