묻고답하기
검색부분 문의 입니다.
2012.07.11 22:40
www.pankoeasia.com을 작업중인데 main 좌측 하단에
서브쿼리 xml을 만들었는데 정상적으로 동작하지 않습니다..
-------------------------------------------------------------------------------------------------------------
SELECT
*
FROM
xe_documents
WHERE
xe_documents.document_srl in
(
select
document_srl
from
xe_document_extra_vars
where
xe_document_extra_vars.var_idx=2
and
xe_document_extra_vars.value like '$args->tourist_nation'
and
xe_document_extra_vars.eid like 'tourist_nation'
)
and
xe_documents.document_srl in
(
select
document_srl
from
xe_document_extra_vars
where
xe_document_extra_vars.var_idx=3
and
xe_document_extra_vars.value like '$args->tourist_city'
and
xe_document_extra_vars.eid like 'tourist_city'
)
이거를
<query id="getDocumentListWithTourist" action="select">
<tables>
<table name="documents" alias="documents" />
</tables>
<columns>
<column name="documents.*" />
</columns>
<conditions>
<condition operation="equal" column="documents.module_srl" var="module_srl" filter="number" notnull="notnull" pipe="and" />
<condition operation="in" column="documents.document_srl" pipe="and" />
<query alias="documentExtraVars">
<table>
<table name="document_extra_vars" alias="document_extra_vars">
</table>
<columns>
<column name="document_extra_vars.document_srl">
</columns>
<conditions>
<condition operation="equal" column="document_extra_vars.var_idx" var="var_idx1" pipe="and">
<condition operation="like" column="document_extra_vars.value" var="var_value1" pipe="and">
<condition operation="equal" column="document_extra_vars.var_idx" var="var_idx2" pipe="or">
<condition operation="like" column="document_extra_vars.value" var="var_value2" pipe="and">
</conditions>
</query>
</conditions>
<navigation>
<index var="sort_index" default="documents.list_order" order="order_type" />
<list_count var="list_count" default="20" />
</navigation>
</query>
-----------------------------------------------------------------------------------------------------------------------
왜동작을 안할까요 ㅠㅠ?
