ㄴrㅎnㅂrㄹrㄱi

테이블 생성 DROP TABLE IF EXISTS `test`.`tbl_sp`; CREATE TABLE `test`.`tbl_sp` ( `SEQ` int(10) unsigned NOT NULL auto_increment, `DATA` varchar(45) default NULL, PRIMARY KEY (`SEQ`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 데이터 생성 INSERT INTO test.tbl_sp(DATA) VALUES ('mysql'), ('java'), ('hibernate'), ('spring'), ('zapatec'), ('jexcel'), ('iReport'), ('json') ; 프로시저 작성(spDynamicQuery.sql) DELIMITER $$ D..

아래 소개된 SQL 소스 코드는 3가지의 MySQL 프로시져(PROCEDURE)를 이용해서 테이블 중에 개별 레코드의 특정 컬럼의 문자열을 구분자로 분리해서 별도의 테이블에 각각 하나의 레코드로 기록할 수 있도록 합니다. 출처 : http://phpschool.com/gnuboard4/bbs/board.php?bo_table=tipntech&wr_id=64862&page=2 DROP TABLE IF EXISTS my_bundles; CREATE TABLE my_bundles(seq int auto_increment, total int, bundle text, PRIMARY KEY (seq)); INSERT INTO my_bundles(total,bundle) VALUES (3,"JAVASCRIPT,ACT..

작성자 : Historymaker 출처 : http://phpschool.com/gnuboard4/bbs/board.php?bo_table=tipntech&wr_id=64962&page=2 Microsoft 보안 공지 MS08-078 - 긴급 2008.12.18 ** 어제 발표가 오늘에야 본;; 물론 알고 계신분들도 계시지만.. 모르시는 분을 위해서 올려드립니다. MS 패치 다운로드 http://www.microsoft.com/korea/technet/security/bulletin/MS08-078.mspx - 영향 받는 시스템 Microsoft Internet Explorer 5.01 Microsoft Internet Explorer 6 Windows Internet Explorer 7 Windows ..

================================================================= 키 | 코드(숫자) ================================================================= ←(백스패이스) = 8 TAB = 9 ENTER = 13 SHIFT = 16 CTRL = 17 ALT = 18 PAUSEBREAK = 19 CAPSLOOK = 20 한/영 = 21 한자 = 25 ESC = 27 스패이스 = 32 PAGEUP = 33 PAGEDN = 34 END = 35 HOME =36 ←(중간) = 37 ↑(중간) = 38 →(중간) = 39 ↓(중간) = 40 INSERT = 45 DELETE = 46 0 = 48 1 = 49 2 =..

DHTML Color Picker Free to use on your own projects! http://www.nofunc.com/DHTML_Color_Picker Originally was developed for ColorJack: Studio — feel free to download the .zip Want another color picker? Color Sphere or Color Picker v2

http://www.zkoss.org/ ZK is an open-source Ajax Web framework that enables rich user interface for Web applications with little programming. With event-driven components and a markup language, developing is as simple as programming desktops and authoring HTML. 다운로드 사이트 : http://www.zkoss.org/download/ Downloads ZK 2.3 Standard Distribution Package Description zk-2.3.0.zip zk-2.3.0.tar.gz The bin..

Ajax Upload Iframe Ajax function startCallback() { // make something useful before submit (onStart) return true; } function completeCallback(response) { // make something useful after (onComplete) document.getElementById('nr').innerHTML = parseInt(document.getElementById('nr').innerHTML) + 1; document.getElementById('r').innerHTML = response; } Name: File: # of submited forms: 0 last submit resp..

데모확인 : http://createwebapp.com/try/ Lean how Include the files in the We will install the widget for a text field named “consumerName”. Let’s create an instance of the Autocomplete object, write the code after the text field. The first argument is a String - “consumerName”, it specified the text field by its name attribute. The second argument is a Function, it is used to make retrieval URIs, wh..