랩제이

[mysql] select procedure 만들기 DELIMITER $$drop procedure if exists ebizin4.USP_Interface_Member_GetEducationCourceByButton$$ CREATE PROCEDURE USP_Interface_Member_GetEducationCourceByButton(in code int)BEGINSELECT E_TRAINING_LIST_ID ,E_KIND_ID ,E_NM ,EX_DATE ,E_TIME ,E_PRICE ,E_RETURN_PRICE ,E_RETURN_ABLE ,E_COMPANY_NM ,ETC1 ,ETC2 ,REG_ID ,REG_DATE FROM e_training_list WHERE E_KIND_ID = code;END$..

[ibatis] sql문 예제1 select SELECT ROW_NUMBER() OVER(ORDER BY tbl2.DISP_ORDER ASC) AS rowNo, tbl2.MENU_ID AS menuId, tbl2.MENU_NM AS menuNm, tbl2.DISP_ORDER AS dispOrder, tbl2.LVL AS lvl, tbl2.UPPER_MENU_ID AS upperMenuId, tbl2.MENU_URL AS menuUrl, tbl2.USE_YN AS useYn, tbl1.AUTH_GRP_CD AS authGrpCd, tbl1.REG_DT AS regDt, tbl1.REG_ID AS regId, tbl1.MOD_DT AS modDt, tbl1.MOD_ID AS modId, (CASE WHEN ..

select text from all_source where type = 'TRIGGER' and NAME ='트리거이름

select '', '', day1, day2, day3, count(schoolno)-sum(value1) value1, sum(value1) value2, sum(extend_cnt) value3 from ( select to_char(d.usestart,'YYYY') day1, to_char(d.usestart,'MM') day2, to_char(d.usestart,'DD') day3, d.schoolno schoolno, to_char(usestart,'DD'), to_char(regtime,'DD'), decode(to_char(usestart,'DD'),to_char(regtime,'DD'),0,1) value1, extend_cnt from seatcode c, seatbookingview ..

select box 값 가져오기 writeLog('value1 = '+value1); writeLog('value = '+$("selUseTime").value); writeLog('text = '+$("selUseTime").text); // 나오지 않음 writeLog('selectedIndex = '+$("selUseTime").selectedIndex); writeLog('length = '+$("selUseTime").length); writeLog('length = '+$("selUseTime").options[$("selUseTime").selectedIndex].text); writeLog('length = '+$("selUseTime").options[$("selUseTime").sele..

- explore, firefox 둘다 만족하기 function setSelYear1(value1) { var select1 = document.createElement("select"); select1.setAttribute("id","sel1"); var optionList = document.createElement("option"); optionList.setAttribute("value","25"); var optionListText = document.createTextNode("1시간00"); optionList.appendChild(optionListText); select1.appendChild(optionList); var selectBoxNode = document.getElement..

select box 에서 다중 선택 후에 form post로 넘겼을 때 java 단에서 아래 코드로 받으면 된다. String[] group0_id = ServletRequestUtils.getStringParameters(request, "group0_id");