Changeset 2953 for pykota/trunk/cgi-bin/printquota.cgi

Timestamp:

06/20/06 23:01:00 (18 years ago)

Author:

jerome

Message:

Fixed date formatting problems with MySQL.

Files:

• pykota/trunk/cgi-bin/printquota.cgi (modified) (2 diffs)

pykota/trunk/cgi-bin/printquota.cgi

@@ -241 +241 @@
                         else :    
                             billingcode_url = None
+                        curdate = DateTime.ISO.ParseDateTime(str(job.JobDate))
                         self.report.append('<tr class="%s">%s</tr>' % \
                                               (oddevenclass, \
                                                "".join(["<td>%s</td>" % (h or "&nbsp;") \
-                                                  for h in (str(job.JobDate[:19]), \
+                                                  for h in (str(curdate)[:19], \
                                                             _(job.JobAction), \
                                                             username_url, \
@@ -264 +265 @@
                                                             job.JobPages)])))
                     self.report.append('</table>')
-                    d = DateTime.ISO.ParseDateTime(str(job.JobDate))
                     dico = { "history" : 1,
-                             "datelimit" : "%04i%02i%02i %02i:%02i:%02i" % (d.year, d.month, d.day, d.hour, d.minute, d.second),
+                             "datelimit" : "%04i-%02i-%02i %02i:%02i:%02i" \
+                                                         % (curdate.year, \
+                                                            curdate.month, \
+                                                            curdate.day, \
+                                                            curdate.hour, \
+                                                            curdate.minute, \
+                                                            curdate.second),
                            }
                     if user and user.Exists :