{pbcms:loopsql sql="select cl_id,cl_name,cl_path,cl_default,fileexname,cl_con_sub=case when len(cl_con_sub)>100 then substring(cl_con_sub,0,100)+'...' else cl_con_sub end from Cy_Column where cl_xs<>0"}
{/pbcms:loopsql}
{pbcms:loopsql sql="select title_sub=case when len(title)>10 then substring(title,0,10)+'...' else title end,id,classid from Cy_News where classid in (13,14)"}