· 고객사 : 크리스피드
· 이메일 : skfl1694@naver.com

<isNotEmpty property="SCH_CONT" prepend="AND">
<isEqual property="SCH_CLS" compareValue="A">
UPPER(REPLACE(BUDG_M.RSPRJ_NM,' ','')) LIKE '%'||UPPER(REPLACE(#SCH_CONT#,' ',''))||'%'
</isEqual>
<isEqual property="SCH_CLS" compareValue="B">
UPPER(RPRJ_S.APPLY_BSNS_NM) LIKE '%' || UPPER(#SCH_CONT#) || '%'
</isEqual>
<isEqual property="SCH_CLS" compareValue="C">
UPPER(RPRJ_S.DETL_BSNS_NM) LIKE '%' || UPPER(#SCH_CONT#) || '%'
</isEqual>
<isEqual property="SCH_CLS" compareValue="D">
UPPER(RPRJ_S.ASINS_NM) LIKE '%' || UPPER(#SCH_CONT#) || '%'
</isEqual>
<isEqual property="SCH_CLS" compareValue="E">
UPPER(RPRJ_S.OPRTN_INSTT_NM) LIKE '%' || UPPER(#SCH_CONT#) || '%'
</isEqual>
</isNotEmpty>

이 부분을
AI 스크립트에서
if(!"".equals(SCH_CONT)){
if("A".equals(SCH_CLS)){
sql_dd += "AND UPPER(REPLACE(BUDG_M.RSPRJ_NM,' ','')) LIKE '%'||UPPER(REPLACE('^SCH_CONT^',' ',''))||'%'";
}else if("B".equals(SCH_CLS)){
sql_dd += "AND UPPER(RPRJ_S.APPLY_BSNS_NM) LIKE '%' || UPPER('^SCH_CONT^') || '%'' ";
}else if("C".equals(SCH_CLS)){
sql_dd += "AND UPPER(RPRJ_S.DETL_BSNS_NM) LIKE '%' || UPPER('^SCH_CONT^') || '%' ";
}else if("D".equals(SCH_CLS)){
sql_dd += "AND UPPER(RPRJ_S.ASINS_NM) LIKE '%' || UPPER('^SCH_CONT^') || '%'";
}else if("E".equals(SCH_CLS)){
sql_dd += "AND UPPER(RPRJ_S.OPRTN_INSTT_NM) LIKE '%' || UPPER('^SCH_CONT^') || '%' ";
}
}
이렇게 써주었는데 오류가 나 문의 드립니다

010.8932.3358 연락 부탁합니다!