Changeset 17144 for branches/comu-ver2/data/class/pages/admin/mail/LC_Page_Admin_Mail_Template.php

Timestamp:

2008/03/13 03:15:22 (16 years ago)

Author:

shutta

Message:

チケット #194 の修正。
(PostgreSQL 8.3 で、substring()で切り出すには、text型でないとエラーになる不具合の修正。)

File:

• branches/comu-ver2/data/class/pages/admin/mail/LC_Page_Admin_Mail_Template.php (modified) (1 diff)

branches/comu-ver2/data/class/pages/admin/mail/LC_Page_Admin_Mail_Template.php

@@ -87 +87 @@
 
 
-        $sql = "SELECT *, (substring(create_date, 1, 19)) as disp_date FROM dtb_mailmaga_template WHERE del_flg = 0 ORDER BY create_date DESC";
+        $sql = "SELECT *, create_date as disp_date FROM dtb_mailmaga_template WHERE del_flg = 0 ORDER BY create_date DESC";
         $this->list_data = $conn->getAll($sql);
+        $this->list_data['disp_date'] = substr($this->list_data['disp_date'], 0, 19);
 
         $objView->assignobj($this);