묻고답하기
게시물 총 글수 카운트하는 쿼리가 있나요?
2014.04.16 10:13
{@
$args->module_srl = $planet->getPlanetSrl();
$output = executeQuery('document.getDocumentCount', $args);
}
{$output->data->count}
응용해서 그 모듈의 총 글자수를 구하려고 하는데 쿼리문을 수정하는데
이건 뭐 신세계를 보는 느낌입니다
<condition operation="like" column="title" var="s_title" />
<condition operation="like" column="content" var="s_content" pipe="and" />
<condition operation="like" column="user_name" var="s_user_name" pipe="and" />
<condition operation="like" column="user_id" var="s_user_id" pipe="or" />
<condition operation="like" column="nick_name" var="s_nick_name" pipe="or" />
<condition operation="like" column="email_address" var="s_email_addres" pipe="or" />
<condition operation="like" column="homepage" var="s_homepage" pipe="or" />
<condition operation="like" column="tags" var="s_tags" pipe="or" />
<condition operation="equal" column="member_srl" var="s_member_srl" pipe="and" />
<condition operation="more" column="readed_count" var="s_readed_count" pipe="or" />
<condition operation="more" column="voted_count" var="s_voted_count" pipe="or" />
<condition operation="less" column="blamed_count" var="s_blamed_count" pipe="or" />
<condition operation="more" column="comment_count" var="s_comment_count" pipe="or" />
<condition operation="more" column="trackback_count" var="s_trackback_count" pipe="or" />
<condition operation="more" column="uploaded_count" var="s_uploaded_count" pipe="or" />
<condition operation="like_prefix" column="regdate" var="s_regdate" pipe="and" />
<condition operation="like_prefix" column="last_update" var="s_last_update" pipe="or" />
<condition operation="like_prefix" column="ipaddress" var="s_ipaddress" pipe="and" />
조건문에서 어디를 수정해야 모듈의 총 글자수를 구할수 있을까요?
아니면 내용의 글자수를 입력받아 사용하지 않는 테이블에 저장하려고한다면 어떤 방법이 있을까요?