% response.setContentType("text/html;charset=UTF-8"); %>
<%@ taglib uri="/tags/struts-html" prefix="html" %>
<%@ taglib uri="http://java.sun.com/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jstl/sql" prefix="sql" %>
<%@ page pageEncoding="euc-jp" %>
select trackback_title
,trackback_id
,trackback_url
from mt_trackback tb
,mt_tbping tbping
where trackback_id = tbping_tb_id
and tbping_created_on =
(
select max(tbping_created_on)
from mt_tbping in_tbping
where in_tbping.tbping_tb_id = tbping.tbping_tb_id
)
order by tbping_created_on desc
limit 5;
-
${entryRow.trackback_title}
select tbping_title
,tbping_blog_name
,tbping_source_url
,to_char(tbping_created_on,'yyyy/mm/dd') as tbping_created_on
from mt_tbping
where tbping_tb_id = ?
order by tbping_created_on desc
иж ${tbRow.tbping_blog_name}
${tbRow.tbping_created_on}