<% '//--- 프로젝트 정보 호출 Dim h_SQL, h_Rcset, h_rs Dim h_PKEY, h_title, h_status, h_report, h_companytype, h_companytype_logo h_companytype_logo = "non_logo.png" h_SQL = " select PKEY " h_SQL = h_SQL + ", JSON_VALUE(PROJECTJSON,'$.must.title') as title " h_SQL = h_SQL + ", JSON_VALUE(PROJECTJSON,'$.must.status') as status " h_SQL = h_SQL + ", JSON_VALUE(PROJECTJSON,'$.must.report') as report " h_SQL = h_SQL + ", JSON_VALUE(PROJECTJSON,'$.must.companytype') as companytype " h_SQL = h_SQL + " from PROJECT " h_SQL = h_SQL & " where PKEY = '"& PRJCODE &"' " h_SQL = h_SQL & "order by id desc " 'response.write "
========================================="& SQL 'response.write fncRequestVariables("LOCAL_ADDR") Set h_rs = DBExec(h_SQL,"kon") If Not h_rs.EOF Then h_PKEY = h_rs(0) h_title = h_rs(1) h_status = h_rs(2) h_report = h_rs(3) h_companytype = h_rs(4) End If Call DBExecClose(h_rs) 'response.write "
DBExec TEST [ "& h_PKEY &" ] , [ "& h_title &" ] , [ "& h_status &" ] , [ "& h_report &" ] , [ "& h_companytype &" ] " if( h_companytype = 2 )then h_companytype_logo = "non_krc_logo.png" end if if( h_companytype = 6 )then h_companytype_logo = "KRd_logo.jpg" end if %> <% if h_companytype = 3 then %> <% h_companytype_logo = "kiwi_logo_2.svg" %> <% else %> <% end if %>