Ignore:
Timestamp:
2008/03/13 03:15:22 (16 years ago)
Author:
shutta
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/comu-ver2/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_News.php

    r16741 r17144  
    9898    function lfGetNews(){ 
    9999        $conn = new SC_DBConn(); 
    100         $sql = "SELECT *, cast(substring(news_date,1,10) as date) as news_date_disp FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC"; 
     100        $sql = "SELECT *, cast(news_date as date) as news_date_disp FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC"; 
    101101        $list_data = $conn->getAll($sql); 
    102102        return $list_data; 
Note: See TracChangeset for help on using the changeset viewer.