トピックスはまだありません。

• kowaza
  • request
    • mode {infolist}
    • channelid {'24','25','26'}
    • first {1}
    • last {2}
    • tag
  • result
    • hits
      • channel
        • 1
          • channelid {24}
          • channelname {womanファッション・コワザ}
        • 2
          • channelid {26}
          • channelname {womanライフスタイル・コワザ}
      • total {72}
      • list
        • 1
          • channelid {25}
          • reportid {1158}
          • sourceid {29}
          • sourcename {ウーマンエキサイト}
          • title {冬のうるおいメソッド　vol.2}
          • s_date {200801161100}
          • e_date
          • info {生活習慣や手軽にできるボディケアで、内側からうるおう肌に}
          • top_imgfile {chn25_top_080116.jpg}
          • memo
          • tag
            • 1 {川原妃巳香}
            • 2 {アミノ酸}
        • 2
          • channelid {26}
          • reportid {1155}
          • sourceid {30}
          • sourcename {ウーマンエキサイト}
          • title {カンタン動画編集で、映画監督気分を味わう}
          • s_date {200801111400}
          • e_date
          • info {初心者でも超カンタン。携帯電話やデジカメで撮影したムービーで作品をつくろう}
          • top_imgfile {chn26_top_MAC12060.jpg}
          • memo
          • tag
            • 1 {西川由美子}
            • 2 {アップル}
            • 3 {Mac}
            • 4 {iPhoto}
            • 5 {動画}
            • 6 {iMovie}
  • navigate
    • sourceSql {select sourceid,sourcename from orgrpt_source where flg = 1 and channelid in ('24','25','26')}
    • channelSql {select channelid,channelname from orgrpt_channel where flg = 1 and channelid in ('24','25','26')}
    • infocntSql {select count(*) from orgrpt_reportinfo rep where rep.channelid in ( '24','25','26') and to_char(rep.s_date,'YYYYMMDDHH24MISS') <= to_char(sysdate,'YYYYMMDDHH24MISS') and (rep.e_date is null or to_char(rep.e_date,'YYYYMMDDHH24MISS') > to_char(sysdate,'YYYYMMDDHH24MISS')) and rep.flg = 1}
    • infolistSql {select rep.channelid,rep.reportid,rep.sourceid,rep.title,to_char(rep.s_date,'YYYYMMDDHH24MI') s_date,to_char(rep.e_date,'YYYYMMDDHH24MI') e_date,rep.info,rep.top_imgfile,rep.memo from orgrpt_reportinfo rep where rep.channelid in ('24','25','26') and to_char(rep.s_date,'YYYYMMDDHH24MISS') <= to_char(sysdate,'YYYYMMDDHH24MISS') and (rep.e_date is null or to_char(rep.e_date,'YYYYMMDDHH24MISS') > to_char(sysdate,'YYYYMMDDHH24MISS')) and rep.flg = 1 order by s_date desc,reportid desc}
    • setfirst {1}
    • setlast {2}
    • tSql {select tag from orgrpt_reporttag where reportid = '1155' order by sort}
• list
  • request
    • mode {infolist}
    • channelid {'25'}
    • first {1}
    • last {10}
    • tag
  • error {f=infolist&msg&dberr=db fail(channelSql)}