Hi.
I can not do well in English.
We wrote articles through a translator.
I hope you do too illogical grammar.
var xmlurl="commonAction.do?mode=getMakeXML";
mygrid = new dhtmlXGridObject('gridbox');
mygrid.setImagePath("codebase/imgs/");
mygrid.setHeader("title,1month, 2month, 3month, 4month");
mygrid.setInitWidths("200,80,80,80,80");
mygrid.setColAlign("center,left,left,left,left");
mygrid.setColTypes("ro,ed,ed,ed,ed");
mygrid.setColSorting("na,str,str,str,str");
mygrid.enableMultiline(true);
mygrid.init();
mygrid.setSkin("dhx_skyblue");
mygrid.enableSmartRendering(true, 50);
mygrid.loadXML(xmlurl);
mygrid.attachEvent("onRowSelect",doOnRowSelectedValue);I am making calls from inside the xml in a way that you’re using.
But after I update in the grid, db and want to save on.
<select id="goal_manageList3" resultClass="GoalXmlVO" parameterClass="java.util.HashMap">
<![CDATA[
SELECT
A.SUB_NO || '-' || '0' AS ID
,A.SUB_NO AS SUB_NO
,0 AS PLAN_NO
,A.SUB_TEXT AS GOAL_NM
,to_char(A.SMON1 ,'FM999,999,999,990.099') AS rat01
,to_char(A.SMON2 ,'FM999,999,999,990.099') AS rat02
,to_char(A.SMON3 ,'FM999,999,999,990.099') AS rat03
,to_char(A.SMON4 ,'FM999,999,999,990.099') AS rat04
,to_char(A.SMON5 ,'FM999,999,999,990.099') AS rat05
,to_char(A.SMON6 ,'FM999,999,999,990.099') AS rat06
,to_char(A.SMON7 ,'FM999,999,999,990.099') AS rat07
,to_char(A.SMON8 ,'FM999,999,999,990.099') AS rat08
,to_char(A.SMON9 ,'FM999,999,999,990.099') AS rat09
,to_char(A.SMON10,'FM999,999,999,990.099') AS rat10
,to_char(A.SMON11,'FM999,999,999,990.099') AS rat11
,to_char(A.SMON12,'FM999,999,999,990.099') AS rat12
,to_char(A.SMON12+A.SMON11+A.SMON10+A.SMON9+A.SMON8+A.SMON7+A.SMON6+A.SMON5+A.SMON4+A.SMON3+A.SMON2+A.SMON1,'FM999,999,999,990.099') AS TOT
FROM GOAL_SUBINFO A ]]>
WHERE A.GOAL_NO=#goal_no# /* 녹색경영목표 조건 - 경영목표에 대한 세부목표/추진계획표시 */
AND A.part LIKE #part_code# || '%' /* part_code적용 */
UNION ALL
<![CDATA[
SELECT
A.SUB_NO || '-' || A.PLAN_NO AS ID
,A.SUB_NO AS SUB_NO
,A.PLAN_NO AS PLAN_NO
,' ' || A.PLAN_TEXT AS GOAL_NM
,(CASE WHEN A.SCHECK1 = '1' THEN '실행' WHEN A.GMON1 = '1' THEN '계획'ELSE '' END) AS rat01
,(CASE WHEN A.SCHECK2 = '1' THEN '실행' WHEN A.GMON2 = '1' THEN '계획'ELSE '' END) AS rat02
,(CASE WHEN A.SCHECK3 = '1' THEN '실행' WHEN A.GMON3 = '1' THEN '계획'ELSE '' END) AS rat03
,(CASE WHEN A.SCHECK4 = '1' THEN '실행' WHEN A.GMON4 = '1' THEN '계획'ELSE '' END) AS rat04
,(CASE WHEN A.SCHECK5 = '1' THEN '실행' WHEN A.GMON5 = '1' THEN '계획'ELSE '' END) AS rat05
,(CASE WHEN A.SCHECK6 = '1' THEN '실행' WHEN A.GMON6 = '1' THEN '계획'ELSE '' END) AS rat06
,(CASE WHEN A.SCHECK7 = '1' THEN '실행' WHEN A.GMON7 = '1' THEN '계획'ELSE '' END) AS rat07
,(CASE WHEN A.SCHECK8 = '1' THEN '실행' WHEN A.GMON8 = '1' THEN '계획'ELSE '' END) AS rat08
,(CASE WHEN A.SCHECK9 = '1' THEN '실행' WHEN A.GMON9 = '1' THEN '계획'ELSE '' END) AS rat09
,(CASE WHEN A.SCHECK10 = '1' THEN '실행' WHEN A.GMON10 = '1' THEN '계획'ELSE '' END) AS rat10
,(CASE WHEN A.SCHECK11 = '1' THEN '실행' WHEN A.GMON11 = '1' THEN '계획'ELSE '' END) AS rat11
,(CASE WHEN A.SCHeCK12 = '1' THEN '실행' WHEN A.GMON12 = '1' THEN '계획'ELSE '' END) AS rat12
,'' AS TOT
FROM GOAL_PLAN A INNER JOIN GOAL_SUBINFO B ON A.goal_no=B.goal_no AND A.sub_no=B.sub_no ]]>
WHERE A.GOAL_NO=#goal_no# /* 녹색경영목표 조건 - 경영목표에 대한 세부목표/추진계획표시 */
AND B.part LIKE #part_code# || '%' /* part_code적용 */
ORDER BY 1,2
</select>But my query is complex,
c.render_sql c.render_table or hard to.
php the looks of it, call (php.get / php), modification (php / update_all.php) sseudeonde separately.
Using java c.render_sql not doing the correct would not be?
Or to save the table have only one … How do I know?
(Twice in lines like the above xml 3month I want to modify data in and
What are you doing in the value be?
Currently stored in db or altered state if there is another way which is capable hope you give.