2009.06.23 08:01
오랜만에 찾아봤다..
예전엔 매일 듣던 곡인데..
한참 안들었넹. 후~


Posted by rainmaker4
2009.06.20 12:59
SELECT ins_title FROM TBL_EMFISH_INSIDE WHERE INS_SEQ = :ins_seq in
((SELECT MAX(INS_SEQ) FROM TBL_EMFISH_INSIDE WHERE INS_SEQ < :ins_seq),
(SELECT MIN(INS_SEQ) FROM TBL_EMFISH_INSIDE WHERE INS_SEQ > :ins_seq))

/*성현씨.. 이렇게 하거나!!!!!!*/
SELECT * FROM TBL_EMFISH_INSIDE WHERE INS_SEQ = :ins_seq
or INS_SEQ =(SELECT MAX(INS_SEQ) FROM TBL_EMFISH_INSIDE WHERE INS_SEQ < :ins_seq)
or INS_SEQ =(SELECT MIN(INS_SEQ) FROM TBL_EMFISH_INSIDE WHERE INS_SEQ > :ins_seq);
 

 /*이게 정답이네요.ㅋㅋㅋㅋ덕분에 공부 하고 갑니다...ㅋㅋ*/
select * from TBL_EMFISH_INSIDE
where INS_SEQ in(
    (select max(INS_SEQ) from TBL_EMFISH_INSIDE where INS_SEQ < :ins_seq)    /*검색 전 내용*/
    ,:ins_seq    /*검색내용*/
    ,(select min(INS_SEQ) from TBL_EMFISH_INSIDE where INS_SEQ > :ins_seq))    /*검색 다음 내용*/
Posted by rainmaker4
2009.06.17 23:32
으흠..;;  mvc 모델로 값을 넣은 후에 리프레쉬를 몇번 했더니만. 데이터가 리프레쉬 한 수만큼 늘어나는걸 목격했다
허걱!! -0-;
팀장님께 굽신굽신 뭥미? 하는 와중에.. redirect 를 true 로 바꾸라는 말을 듣고 해본 결과
답이 나왔다. 혹시나 나중에도 문제 생길것을 대비하여 조금 알아봤다..;;



## Struts의 주요 클래스 ##
1. ActionServlet
   - servlet.
   - 모든 클라이언트의 요청을 제일 먼저 맞이한다.
   - 톰캣 구동시 같이 메모리에 로딩
   - init() 메소드를 통해 /WEB-INF/struts-config.xml
     파일에 있는 내용들을 ServletContext 객체에 저장
2. Action

   - Controller로서 Model 영역과 접점을 가지는 객체.

   - 사용자의 HTTP 요청에 반응하는 객체로서, struts-config.xml에 저장된

     action element에 따라 객체가 생성됨. 이때 객체는 매번 생성되는 것이

     아니라 단 한번 생성되어 재 사용된다.

   - 보통 직접 Action 클래스를 사용하지 않고 Action 클래스를 상속받는 클래스를

     제작하게 되고 Action 클래스가 가지고 있는 execute() 메소드를 오버라이딩하게 한다.

   - 실제 개발자는 Model과의 작업을 위해 execute() 메소드에서

     Model쪽 Manager 객체를 생성하고 관련 비즈니스 메소드를 호출하는 작업을 한다.

3. RequestProcessor

   - ActionServlet을 대신하여 Action의 execute() 메소드를 호출하는 역할.

   - execute() 메소드 호출 결과인 ActionForward에 따라 View를 연결한다.

4. ActionForward

   - Controller의 execute() 호출 결과로서, 페이지 이동에 대한 정보를 객체화 한 것.

   - 객체를 통해 forward할 것인지, redirect할 것인지 정해진다.

5. ActionForm

   - HTTP 요청에 따라 파라미터를 처리하기 위한 클래스.

   - 테이터를 저장하고 전달하는 DTO(Data Transfer Object) 객체.

   - ActionForm을 상속받는 형태로 작성.

   - ActionForm 객체의 필드는 자동으로 세팅된다.

   - reset() 메소드로 필드 초기화

   - validate() 메소드로 유효성 검증

   - 보통의 Bean 클래스처럼 필드에 접근처리할 수 있는 setter, getter를 작성하면 된다.

6. ActionMapping

   - 사용자 HTTP 접근에 따라 어떠한 Action 객체가 사용되어야 하는지, 그 Action 처리 후

     어느 페이지로 이동해야 하는지에 대한 정보가 struts-config.xml에 있다.

     이 ActionMapping은 그 중에서 이동할 페이지에 대한 맵핑을 가진 객체이다.

     지정된 이름의 forward를 찾아서 ActionForward 객체를 돌려주게 된다.

7. ActionMessages

   - 각종 메시지를 처리하는 클래스. (에러 포함)

8. ActionMessage

   - 한 개의 메시지 처리.

9. ActionErrors

   - 각종 에러 메시지를 처리하는 클래스

   - ActionMessages를 상속받고 있음.

10. ActionError

   - 한 개의 에러 메시지 처리.

출처 : [직접 서술] 블로그 집필 - 幸せになれ

Posted by rainmaker4
2009.06.16 08:57

span ,A 태그에 title 이용하여 Tooltip을 사용한 는 경우가 많습니다.
이때 2줄로 변경이 하든 방법입니다.

소스예)
<span title="1번째 중입니다.&#10;2번째 줄입니다.">ToolTip Test</span>
마우스를 올려주세요
 
줄단위의 \r\n 를  &#10; 로 표현하시면 Tootip 이 2줄로 나타나게 됩니다.


출처 : 대훈씨 블록

Posted by rainmaker4
2009.06.12 11:10
정말 갑갑한 지로다..;;
한동안 이거 경로 어케 되는지 헷갈려서..
결국은 적어두기로 했다..
/ <== 이놈이란.. 참.. 하앜..


../../images/ ==   http://localhost:8080/images/bold_on.gif
/../images/   ==   http://localhost:8080/images/underline_on.gif
/images/      ==   http://localhost:8080/images/bold_on.gif
../images/    ==   http://localhost:8080/이름/images/bold_on.gif
images/       ==   http://localhost:8080/이름/sample/images/bold_on.gif
./images/     ==   http://localhost:8080/이름/sample/images/bold_on.gif
images/       ==   http://localhost:8080/이름/sample/images/bold_on.gif
Posted by rainmaker4
2009.06.10 10:08
실행창에서 regedit 입력한 후,
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\Notify 항목을 찾아
폴더 전체를 삭제합니다.

그리고, 실행창에서 %windir%\system32\wgatray.exe /u 를 실행한 후, 재부팅을 합니다.
재부팅 후, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\Notify
항목이 삭제 되었는지, 확인하고, 삭제되지 않았다면 재 삭제하시면 됩니다.

그리고, 실행창에서 아래와 같이 실행하시면 됩니다.
1. cmd /c "del %windir%\system32\wgatray.exe"
2. cmd /c "del %windir%\system32\WGAlogon.dll"
3. cmd /c "rmdir /s /q %windir%\SoftwareDistribution\Download\6c4788c9549d437e76e1773a7639582a"

위 3개를 실행한 후, 다시 재부팅해 보면 정품 인증 메시지가 없어집니다.

출처 : 이것도 승호씨 블록
Posted by rainmaker4
2009.06.10 10:08
실행창에서 notepad 명령어를 입력하여 메모장을 엽니다.
아래와 같이 입력한 후, 저장합니다.

[Shell]
Command = 2
IconFile=explorer.exe,3
[Taskbar]
Command=ToggleDesktop

파일명은 바로가기만들기.scf 로 저장합니다.

출처 : 승호씨 블록.
Posted by rainmaker4
2009.06.08 19:05

아 촙내 고생혔다..;; 하루 종일 뻘짓만 하다가.. 퇴근시간 1시간 남겨두고 문뜩 해야할 일이 떠올랐을때의 압박..
아 제길순.   ㅠ_ㅠ;;
mysql 쿼리 살포시 짜공..

아 조심해야 할 것은..
sp 만들때...

# Count 문
delimiter//
drop procedure if exists sp_getCount//

CREATE PROCEDURE sp_getCount()
BEGIN
SELECT count(*) from testMember;
END;
//

delimiter ;

이렇게 delimiter 부분까지 긁어다가 F9 번 때리지 말고.. 저놈은 살포시 빼고 때리라는 것이다.
후하~~ 노가다 작업이지만.. 고생혔넹.. ㅜ_ㅜ;;
행여 이거 모르는 분 있으시면.. 걍 하라는 대로 하면 됨..;;
sp 열나게 만들다가.. delimiter 까지 긁어서 F9 때리면 무시무시한 일이 벌어짐!!!
(사실 일 벌어지는거 없음..; 에러만 살포시)
혹시 간단한 테이블 테스트 할거면 긁어가세요!
오늘도 하루일과를 마치고.. 난 군대 후임들 만나서 소주 1병 빨러 ㄱㄱ



#디비 생성
create database testDB;


# 테이블 생성
create table testMember(
idx int not null auto_increment primary key,
member_id varchar(10) not null,
member_pw varchar(10) not null,
member_regdate datetime not null,
member_name varchar(20) not null,
member_addr varchar(100) not null,
member_email varchar(80) not null
);


#테이블에 칼럼 추가하기
alter table testMember add member_sex char(1) not null;


#현재의 디비에서 테이블 목록
show tables;


#현재 테이블에서 칼럼 정보 보기
show columns from testMember;


#테이블의 상태 확인
show table status;


# 현재 시스템 시간 보기
select now()


# insert 문
insert into testMember values('','girltester','goodman',now(),'jannet','yongsan, yongsan-gu, seoul city, korean','girl@01inter.com','y');


# select 문
select * from testMember;


# delete 문
delete from testMember where idx = '6';


# Count 문
delimiter//
drop procedure if exists sp_getCount//

CREATE PROCEDURE sp_getCount()
BEGIN
SELECT count(*) from testMember;
END;
//
delimiter ;


# Select 문
delimiter//
drop procedure if exists sp_getSelect//

CREATE PROCEDURE sp_getSelect()
BEGIN
SELECT * from testMember;
END;
//
delimiter ;


call sp_insert('','88434','38832',now(),'8888','newyork, yongsan-gu, seoul city, korean','aaa@test.com','f');


# Insert 문
delimiter//
drop procedure if exists sp_Insert//

create procedure sp_Insert(in idx int,in member_id varchar(10),in member_pw varchar(10),in member_regdate datetime,in member_name varchar(20),in member_addr varchar(100),in member_email varchar(20),in member_sex char(1))
begin
insert into testMember values(idx, member_id,member_pw,now(),member_name,member_addr,member_email,member_sex);
end;
//
delimiter;


# Delete 문
delimiter//
drop procedure if exists sp_Delete//

CREATE PROCEDURE sp_Delete(in valueidx int)
BEGIN
delete from testMember where idx = valueidx;
END;
//
delimiter ;


call sp_Delete('2');


# Update 문
delimiter//
drop procedure if exists sp_Update//

create procedure sp_Update(in up_idx int,in up_member_id varchar(10),in up_member_pw varchar(10),in up_member_regdate datetime,in up_member_name varchar(20),in up_member_addr varchar(100),in up_member_email varchar(20),in up_member_sex char(1))
begin
update testMember set member_id = up_member_id, member_pw = up_member_id,member_regdate = up_member_regdate, member_name = up_member_regdate, member_addr = up_member_addr, member_email = up_member_email, member_sex = up_member_sex where idx = up_idx;
end;
//
delimiter;


call sp_Update(9,'modify','modpassword',now(),'mod','mod test address','mod email','m');

Posted by rainmaker4
2009.06.08 18:20

Mysql Error Code

 

Name Error Code SQLSTATE
ER_HASHCHK 1000 HY000
ER_NISAMCHK 1001 HY000
ER_NO 1002 HY000
ER_YES 1003 HY000
ER_CANT_CREATE_FILE 1004 HY000
ER_CANT_CREATE_TABLE 1005 HY000
ER_CANT_CREATE_DB 1006 HY000
ER_DB_CREATE_EXISTS 1007 HY000
ER_DB_DROP_EXISTS 1008 HY000
ER_DB_DROP_DELETE 1009 HY000
ER_DB_DROP_RMDIR 1010 HY000
ER_CANT_DELETE_FILE 1011 HY000
ER_CANT_FIND_SYSTEM_REC 1012 HY000
ER_CANT_GET_STAT 1013 HY000
ER_CANT_GET_WD 1014 HY000
ER_CANT_LOCK 1015 HY000
ER_CANT_OPEN_FILE 1016 HY000
ER_FILE_NOT_FOUND 1017 HY000
ER_CANT_READ_DIR 1018 HY000
ER_CANT_SET_WD 1019 HY000
ER_CHECKREAD 1020 HY000
ER_DISK_FULL 1021 HY000
ER_DUP_KEY 1022 23000
ER_ERROR_ON_CLOSE 1023 HY000
ER_ERROR_ON_READ 1024 HY000
ER_ERROR_ON_RENAME 1025 HY000
ER_ERROR_ON_WRITE 1026 HY000
ER_FILE_USED 1027 HY000
ER_FILSORT_ABORT 1028 HY000
ER_FORM_NOT_FOUND 1029 HY000
ER_GET_ERRNO 1030 HY000
ER_ILLEGAL_HA 1031 HY000
ER_KEY_NOT_FOUND 1032 HY000
ER_NOT_FORM_FILE 1033 HY000
ER_NOT_KEYFILE 1034 HY000
ER_OLD_KEYFILE 1035 HY000
ER_OPEN_AS_READONLY 1036 HY000
ER_OUTOFMEMORY 1037 HY001
ER_OUT_OF_SORTMEMORY 1038 HY001
ER_UNEXPECTED_EOF 1039 HY000
ER_CON_COUNT_ERROR 1040 08004
ER_OUT_OF_RESOURCES 1041 08004
ER_BAD_HOST_ERROR 1042 08S01
ER_HANDSHAKE_ERROR 1043 08S01
ER_DBACCESS_DENIED_ERROR 1044 42000
ER_ACCESS_DENIED_ERROR 1045 42000
ER_NO_DB_ERROR 1046 42000
ER_UNKNOWN_COM_ERROR 1047 08S01
ER_BAD_NULL_ERROR 1048 23000
ER_BAD_DB_ERROR 1049 42000
ER_TABLE_EXISTS_ERROR 1050 42S01
ER_BAD_TABLE_ERROR 1051 42S02
ER_NON_UNIQ_ERROR 1052 23000
ER_SERVER_SHUTDOWN 1053 08S01
ER_BAD_FIELD_ERROR 1054 42S22
ER_WRONG_FIELD_WITH_GROUP 1055 42000
ER_WRONG_GROUP_FIELD 1056 42000
ER_WRONG_SUM_SELECT 1057 42000
ER_WRONG_VALUE_COUNT 1058 21S01
ER_TOO_LONG_IDENT 1059 42000
ER_DUP_FIELDNAME 1060 42S21
ER_DUP_KEYNAME 1061 42000
ER_DUP_ENTRY 1062 23000
ER_WRONG_FIELD_SPEC 1063 42000
ER_PARSE_ERROR 1064 42000
ER_EMPTY_QUERY 1065 42000
ER_NONUNIQ_TABLE 1066 42000
ER_INVALID_DEFAULT 1067 42000
ER_MULTIPLE_PRI_KEY 1068 42000
ER_TOO_MANY_KEYS 1069 42000
ER_TOO_MANY_KEY_PARTS 1070 42000
ER_TOO_LONG_KEY 1071 42000
ER_KEY_COLUMN_DOES_NOT_EXITS 1072 42000
ER_BLOB_USED_AS_KEY 1073 42000
ER_TOO_BIG_FIELDLENGTH 1074 42000
ER_WRONG_AUTO_KEY 1075 42000
ER_READY 1076 00000
ER_NORMAL_SHUTDOWN 1077 00000
ER_GOT_SIGNAL 1078 00000
ER_SHUTDOWN_COMPLETE 1079 00000
ER_FORCING_CLOSE 1080 08S01
ER_IPSOCK_ERROR 1081 08S01
ER_NO_SUCH_INDEX 1082 42S12
ER_WRONG_FIELD_TERMINATORS 1083 42000
ER_BLOBS_AND_NO_TERMINATED 1084 42000
ER_TEXTFILE_NOT_READABLE 1085 HY000
ER_FILE_EXISTS_ERROR 1086 HY000
ER_LOAD_INFO 1087 HY000
ER_ALTER_INFO 1088 HY000
ER_WRONG_SUB_KEY 1089 HY000
ER_CANT_REMOVE_ALL_FIELDS 1090 42000
ER_CANT_DROP_FIELD_OR_KEY 1091 42000
ER_INSERT_INFO 1092 HY000
ER_UPDATE_TABLE_USED 1093 HY000
ER_NO_SUCH_THREAD 1094 HY000
ER_KILL_DENIED_ERROR 1095 HY000
ER_NO_TABLES_USED 1096 HY000
ER_TOO_BIG_SET 1097 HY000
ER_NO_UNIQUE_LOGFILE 1098 HY000
ER_TABLE_NOT_LOCKED_FOR_WRITE 1099 HY000
ER_TABLE_NOT_LOCKED 1100 HY000
ER_BLOB_CANT_HAVE_DEFAULT 1101 42000
ER_WRONG_DB_NAME 1102 42000
ER_WRONG_TABLE_NAME 1103 42000
ER_TOO_BIG_SELECT 1104 42000
ER_UNKNOWN_ERROR 1105 HY000
ER_UNKNOWN_PROCEDURE 1106 42000
ER_WRONG_PARAMCOUNT_TO_PROCEDURE 1107 42000
ER_WRONG_PARAMETERS_TO_PROCEDURE 1108 HY000
ER_UNKNOWN_TABLE 1109 42S02
ER_FIELD_SPECIFIED_TWICE 1110 42000
ER_INVALID_GROUP_FUNC_USE 1111 42000
ER_UNSUPPORTED_EXTENSION 1112 42000
ER_TABLE_MUST_HAVE_COLUMNS 1113 42000
ER_RECORD_FILE_FULL 1114 HY000
ER_UNKNOWN_CHARACTER_SET 1115 42000
ER_TOO_MANY_TABLES 1116 HY000
ER_TOO_MANY_FIELDS 1117 HY000
ER_TOO_BIG_ROWSIZE 1118 42000
ER_STACK_OVERRUN 1119 HY000
ER_WRONG_OUTER_JOIN 1120 42000
ER_NULL_COLUMN_IN_INDEX 1121 42000
ER_CANT_FIND_UDF 1122 HY000
ER_CANT_INITIALIZE_UDF 1123 HY000
ER_UDF_NO_PATHS 1124 HY000
ER_UDF_EXISTS 1125 HY000
ER_CANT_OPEN_LIBRARY 1126 HY000
ER_CANT_FIND_DL_ENTRY 1127 HY000
ER_FUNCTION_NOT_DEFINED 1128 HY000
ER_HOST_IS_BLOCKED 1129 HY000
ER_HOST_NOT_PRIVILEGED 1130 HY000
ER_PASSWORD_ANONYMOUS_USER 1131 42000
ER_PASSWORD_NOT_ALLOWED 1132 42000
ER_PASSWORD_NO_MATCH 1133 42000
ER_UPDATE_INFO 1134 HY000
ER_CANT_CREATE_THREAD 1135 HY000
ER_WRONG_VALUE_COUNT_ON_ROW 1136 21S01
ER_CANT_REOPEN_TABLE 1137 HY000
ER_INVALID_USE_OF_NULL 1138 42000
ER_REGEXP_ERROR 1139 42000
ER_MIX_OF_GROUP_FUNC_AND_FIELDS 1140 42000
ER_NONEXISTING_GRANT 1141 42000
ER_TABLEACCESS_DENIED_ERROR 1142 42000
ER_COLUMNACCESS_DENIED_ERROR@tab 1143 42000
ER_ILLEGAL_GRANT_FOR_TABLE 1144 42000
ER_GRANT_WRONG_HOST_OR_USER 1145 42000
ER_NO_SUCH_TABLE 1146 42S02
ER_NONEXISTING_TABLE_GRANT 1147 42000
ER_NOT_ALLOWED_COMMAND 1148 42000
ER_SYNTAX_ERROR 1149 42000
ER_DELAYED_CANT_CHANGE_LOCK 1150 HY000
ER_TOO_MANY_DELAYED_THREADS 1151 HY000
ER_ABORTING_CONNECTION 1152 08S01
ER_NET_PACKET_TOO_LARGE 1153 08S01
ER_NET_READ_ERROR_FROM_PIPE 1154 08S01
ER_NET_FCNTL_ERROR 1155 08S01
ER_NET_PACKETS_OUT_OF_ORDER 1156 08S01
ER_NET_UNCOMPRESS_ERROR 1157 08S01
ER_NET_READ_ERROR 1158 08S01
ER_NET_READ_INTERRUPTED 1159 08S01
ER_NET_ERROR_ON_WRITE 1160 08S01
ER_NET_WRITE_INTERRUPTED 1161 08S01
ER_TOO_LONG_STRING 1162 42000
ER_TABLE_CANT_HANDLE_BLOB 1163 42000
ER_TABLE_CANT_HANDLE_AUTO_INCREMENT 1164 42000
ER_DELAYED_INSERT_TABLE_LOCKED 1165 HY000
ER_WRONG_COLUMN_NAME 1166 42000
ER_WRONG_KEY_COLUMN 1167 42000
ER_WRONG_MRG_TABLE 1168 HY000
ER_DUP_UNIQUE 1169 23000
ER_BLOB_KEY_WITHOUT_LENGTH 1170 42000
ER_PRIMARY_CANT_HAVE_NULL 1171 42000
ER_TOO_MANY_ROWS 1172 42000
ER_REQUIRES_PRIMARY_KEY 1173 42000
ER_NO_RAID_COMPILED 1174 HY000
ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE 1175 HY000
ER_KEY_DOES_NOT_EXITS 1176 HY000
ER_CHECK_NO_SUCH_TABLE 1177 42000
ER_CHECK_NOT_IMPLEMENTED 1178 42000
ER_CANT_DO_THIS_DURING_AN_TRANSACTION 1179 25000
ER_ERROR_DURING_COMMIT 1180 HY000
ER_ERROR_DURING_ROLLBACK 1181 HY000
ER_ERROR_DURING_FLUSH_LOGS 1182 HY000
ER_ERROR_DURING_CHECKPOINT 1183 HY000
ER_NEW_ABORTING_CONNECTION 1184 08S01
ER_DUMP_NOT_IMPLEMENTED 1185 HY000
ER_FLUSH_MASTER_BINLOG_CLOSED 1186 HY000
ER_INDEX_REBUILD 1187 HY000
ER_MASTER 1188 HY000
ER_MASTER_NET_READ 1189 08S01
ER_MASTER_NET_WRITE 1190 08S01
ER_FT_MATCHING_KEY_NOT_FOUND 1191 HY000
ER_LOCK_OR_ACTIVE_TRANSACTION 1192 HY000
ER_UNKNOWN_SYSTEM_VARIABLE 1193 HY000
ER_CRASHED_ON_USAGE 1194 HY000
ER_CRASHED_ON_REPAIR 1195 HY000
ER_WARNING_NOT_COMPLETE_ROLLBACK 1196 HY000
ER_TRANS_CACHE_FULL 1197 HY000
ER_SLAVE_MUST_STOP 1198 HY000
ER_SLAVE_NOT_RUNNING 1199 HY000
ER_BAD_SLAVE 1200 HY000
ER_MASTER_INFO 1201 HY000
ER_SLAVE_THREAD 1202 HY000
ER_TOO_MANY_USER_CONNECTIONS 1203 42000
ER_SET_CONSTANTS_ONLY 1204 HY000
ER_LOCK_WAIT_TIMEOUT 1205 HY000
ER_LOCK_TABLE_FULL 1206 HY000
ER_READ_ONLY_TRANSACTION 1207 25000
ER_DROP_DB_WITH_READ_LOCK 1208 HY000
ER_CREATE_DB_WITH_READ_LOCK 1209 HY000
ER_WRONG_ARGUMENTS 1210 HY000
ER_NO_PERMISSION_TO_CREATE_USER 1211 42000
ER_UNION_TABLES_IN_DIFFERENT_DIR 1212 HY000
ER_LOCK_DEADLOCK 1213 40001
ER_TABLE_CANT_HANDLE_FULLTEXT 1214 HY000
ER_CANNOT_ADD_FOREIGN 1215 HY000
ER_NO_REFERENCED_ROW 1216 23000
ER_ROW_IS_REFERENCED 1217 23000
ER_CONNECT_TO_MASTER 1218 08S01
ER_QUERY_ON_MASTER 1219 HY000
ER_ERROR_WHEN_EXECUTING_COMMAND 1220 HY000
ER_WRONG_USAGE 1221 HY000
ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT 1222 21000
ER_CANT_UPDATE_WITH_READLOCK 1223 HY000
ER_MIXING_NOT_ALLOWED 1224 HY000
ER_DUP_ARGUMENT 1225 HY000
ER_USER_LIMIT_REACHED 1226 42000
ER_SPECIFIC_ACCESS_DENIED_ERROR 1227 HY000
ER_LOCAL_VARIABLE 1228 HY000
ER_GLOBAL_VARIABLE 1229 HY000
ER_NO_DEFAULT 1230 42000
ER_WRONG_VALUE_FOR_VAR 1231 42000
ER_WRONG_TYPE_FOR_VAR 1232 42000
ER_VAR_CANT_BE_READ 1233 HY000
ER_CANT_USE_OPTION_HERE 1234 42000
ER_NOT_SUPPORTED_YET 1235 42000
ER_MASTER_FATAL_ERROR_READING_BINLOG 1236 HY000
ER_SLAVE_IGNORED_TABLE 1237 HY000
ER_WRONG_FK_DEF 1238 42000
ER_KEY_REF_DO_NOT_MATCH_TABLE_REF 1239 HY000
ER_CARDINALITY_COL 1240 21000
ER_SUBSELECT_NO_1_ROW 1241 21000
ER_UNKNOWN_STMT_HANDLER 1242 HY000
ER_CORRUPT_HELP_DB 1243 HY000
ER_CYCLIC_REFERENCE 1244 HY000
ER_AUTO_CONVERT 1245 HY000
ER_ILLEGAL_REFERENCE 1246 42S22
ER_DERIVED_MUST_HAVE_ALIAS 1247 42000
ER_SELECT_REDUCED 1248 01000
ER_TABLENAME_NOT_ALLOWED_HERE 1249 42000
ER_NOT_SUPPORTED_AUTH_MODE 1250 08004
ER_SPATIAL_CANT_HAVE_NULL 1251 42000
ER_COLLATION_CHARSET_MISMATCH 1252 42000
ER_SLAVE_WAS_RUNNING 1253 HY000
ER_SLAVE_WAS_NOT_RUNNING 1254 HY000
ER_TOO_BIG_FOR_UNCOMPRESS 1255 HY000
ER_ZLIB_Z_MEM_ERROR 1256 HY000
ER_ZLIB_Z_BUF_ERROR 1257 HY000
ER_ZLIB_Z_DATA_ERROR 1258 HY000
ER_CUT_VALUE_GROUP_CONCAT 1259 HY000
ER_WARN_TOO_FEW_RECORDS 1260 01000
ER_WARN_TOO_MANY_RECORDS 1261 01000
ER_WARN_NULL_TO_NOTNULL 1262 01000
ER_WARN_DATA_OUT_OF_RANGE 1263 01000
ER_WARN_DATA_TRUNCATED 1264 01000
ER_WARN_USING_OTHER_HANDLER 1265 01000
ER_CANT_AGGREGATE_COLLATIONS 1266 42000
ER_DROP_USER 1267 42000
ER_REVOKE_GRANTS 1268 42000
ER_CANT_AGGREGATE_3COLLATIONS 1269 42000
ER_CANT_AGGREGATE_NCOLLATIONS 1270 42000
ER_VARIABLE_IS_NOT_STRUCT 1271 HY000
ER_UNKNOWN_COLLATION 1272 HY000
ER_SLAVE_IGNORED_SSL_PARAMS 1273 HY000
ER_SERVER_IS_IN_SECURE_AUTH_MODE 1274 HY000
ER_WARN_FIELD_RESOLVED 1275 HY000
ER_BAD_SLAVE_UNTIL_COND 1276 HY000
ER_MISSING_SKIP_SLAVE 1277 HY000
ER_UNTIL_COND_IGNORED 1278 HY000

 

 

Error Messages

Error Code Error Message
1000 hashchk
1001 isamchk
1002 NO
1003 YES
1004 Can't create file '%s' (errno: %d)
1005 Can't create table '%s' (errno: %d)
1006 Can't create database '%s' (errno: %d)
1007 Can't create database '%s'; database exists
1008 Can't drop database '%s'; database doesn't exist
1009 Error dropping database (can't delete '%s', errno: %d)
1010 Error dropping database (can't rmdir '%s', errno: %d)
1011 Error on delete of '%s' (errno: %d)
1012 Can't read record in system table
1013 Can't get status of '%s' (errno: %d)
1014 Can't get working directory (errno: %d)
1015 Can't lock file (errno: %d)
1016 Can't open file: '%s' (errno: %d)
1017 Can't find file: '%s' (errno: %d)
1018 Can't read dir of '%s' (errno: %d)
1019 Can't change dir to '%s' (errno: %d)
1020 Record has changed since last read in table '%s'
1021 Disk full (%s). Waiting for someone to free some space...
1022 Can't write, duplicate key in table '%s'
1023 Error on close of '%s' (errno: %d)
1024 Error reading file '%s' (errno: %d)
1025 Error on rename of '%s' to '%s' (errno: %d)
1026 Error writing file '%s' (errno: %d)
1027 '%s' is locked against change
1028 Sort aborted
1029 View '%s' doesn't exist for '%s'
1030 Got error %d from storage engine
1031 Table storage engine for '%s' doesn't have this option
1032 Can't find record in '%s'
1033 Incorrect information in file: '%s'
1034 Incorrect key file for table: '%s'; try to repair it
1035 Old key file for table '%s'; repair it!
1036 Table '%s' is read only
1037 Out of memory. Restart daemon and try again (needed %d bytes)
1038 Out of sort memory. Increase daemon sort buffer size
1039 Unexpected eof found when reading file '%s' (errno: %d)
1040 Too many connections
1041 Out of memory; Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
1042 Can't get hostname for your address
1043 Bad handshake
1044 Access denied for user: '%s'@'%s' to database '%s'
1045 Access denied for user: '%s'@'%s' (Using password: %s)
1046 No Database Selected
1047 Unknown command
1048 Column '%s' cannot be null
1049 Unknown database '%s'
1050 Table '%s' already exists
1051 Unknown table '%s'
1052 Column: '%s' in %s is ambiguous
1053 Server shutdown in progress
1054 Unknown column '%s' in '%s'
1055 '%s' isn't in GROUP BY
1056 Can't group on '%s'
1057 Statement has sum functions and columns in same statement
1058 Column count doesn't match value count
1059 Identifier name '%s' is too long
1060 Duplicate column name '%s'
1061 Duplicate key name '%s'
1062 Duplicate entry '%s' for key %d
1063 Incorrect column specifier for column '%s'
1064 %s near '%s' at line %d
1065 Query was empty
1066 Not unique table/alias: '%s'
1067 Invalid default value for '%s'
1068 Multiple primary key defined
1069 Too many keys specified. Max %d keys allowed
1070 Too many key parts specified. Max %d parts allowed
1071 Specified key was too long. Max key length is %d
1072 Key column '%s' doesn't exist in table
1073 BLOB column '%s' can't be used in key specification with the used table type
1074 Too big column length for column '%s' (max = %d). Use BLOB instead
1075 Incorrect table definition; There can only be one auto column and it must be defined as a key
1076 %s: ready for connections. Version: '%s' socket: '%s' port: %d
1077 %s: Normal shutdown
1078 %s: Got signal %d. Aborting!
1079 %s: Shutdown Complete
1080 %s: Forcing close of thread %ld user: '%s'
1081 Can't create IP socket
1082 Table '%s' has no index like the one used in CREATE INDEX. Recreate the table
1083 Field separator argument is not what is expected. Check the manual
1084 You can't use fixed rowlength with BLOBs. Please use 'fields terminated by'
1085 The file '%s' must be in the database directory or be readable by all
1086 File '%s' already exists
1087 Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld
1088 Records: %ld Duplicates: %ld
1089 Incorrect sub part key. The used key part isn't a string, the used length is longer than the key part or the storage engine doesn't support unique sub keys
1090 You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
1091 Can't DROP '%s'. Check that column/key exists
1092 Records: %ld Duplicates: %ld Warnings: %ld
1093 You can't specify target table '%s' for update in FROM clause
1094 Unknown thread id: %lu
1095 You are not owner of thread %lu
1096 No tables used
1097 Too many strings for column %s and SET
1098 Can't generate a unique log-filename %s.(1-999)
1099 Table '%s' was locked with a READ lock and can't be updated
1100 Table '%s' was not locked with LOCK TABLES
1101 BLOB/TEXT column '%s' can't have a default value
1102 Incorrect database name '%s'
1103 Incorrect table name '%s'
1104 The SELECT would examine more rows than MAX_JOIN_SIZE. Check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is ok
1105 Unknown error
1106 Unknown procedure '%s'
1107 Incorrect parameter count to procedure '%s'
1108 Incorrect parameters to procedure '%s'
1109 Unknown table '%s' in %s
1110 Column '%s' specified twice
1111 Invalid use of group function
1112 Table '%s' uses an extension that doesn't exist in this MySQL version
1113 A table must have at least 1 column
1114 The table '%s' is full
1115 Unknown character set: '%s'
1116 Too many tables. MySQL can only use %d tables in a join
1117 Too many columns
1118 Too big row size. The maximum row size for the used table type, not counting BLOBs, is %ld. You have to change some fields to TEXT or BLOBs
1119 Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld -O thread_stack=#' to specify a bigger stack if needed
1120 Cross dependency found in OUTER JOIN. Examine your ON conditions
1121 Column '%s' is used with UNIQUE or INDEX but is not defined as NOT NULL
1122 Can't load function '%s'
1123 Can't initialize function '%s'; %s
1124 No paths allowed for shared library
1125 Function '%s' already exist
1126 Can't open shared library '%s' (errno: %d %s)
1127 Can't find function '%s' in library'
1128 Function '%s' is not defined
1129 Host '%s' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'
1130 Host '%s' is not allowed to connect to this MySQL server
1131 You are using MySQL as an anonymous users and anonymous users are not allowed to change passwords
1132 You must have privileges to update tables in the mysql database to be able to change passwords for others
1133 Can't find any matching row in the user table
1134 Rows matched: %ld Changed: %ld Warnings: %ld
1135 Can't create a new thread (errno %d). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug
1136 Column count doesn't match value count at row %ld
1137 Can't reopen table: '%s'
1138 Invalid use of NULL value
1139 Got error '%s' from regexp
1140 Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause
1141 There is no such grant defined for user '%s' on host '%s'
1142 %s command denied to user: '%s'@'%s' for table '%s'
1143 %s command denied to user: '%s'@'%s' for column '%s' in table '%s'
1144 Illegal GRANT/REVOKE command. Please consult the manual which privileges can be used
1145 The host or user argument to GRANT is too long
1146 Table '%s.%s' doesn't exist
1147 There is no such grant defined for user '%s' on host '%s' on table '%s'
1148 The used command is not allowed with this MySQL version
1149 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use
1150 Delayed insert thread couldn't get requested lock for table %s
1151 Too many delayed threads in use
1152 Aborted connection %ld to db: '%s' user: '%s' (%s)
1153 Got a packet bigger than 'max_allowed_packet'
1154 Got a read error from the connection pipe
1155 Got an error from fcntl()
1156 Got packets out of order
1157 Couldn't uncompress communication packet
1158 Got an error reading communication packets
1159 Got timeout reading communication packets
1160 Got an error writing communication packets
1161 Got timeout writing communication packets
1162 Result string is longer than max_allowed_packet
1163 The used table type doesn't support BLOB/TEXT columns
1164 The used table type doesn't support AUTO_INCREMENT columns
1165 INSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES
1166 Incorrect column name '%s'
1167 The used storage engine can't index column '%s'
1168 All tables in the MERGE table are not identically defined
1169 Can't write, because of unique constraint, to table '%s'
1170 BLOB/TEXT column '%s' used in key specification without a key length
1171 All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead
1172 Result consisted of more than one row
1173 This table type requires a primary key
1174 This version of MySQL is not compiled with RAID support
1175 You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
1176 Key '%s' doesn't exist in table '%s'
1177 Can't open table
1178 The storage engine for the table doesn't support %s
1179 You are not allowed to execute this command in a transaction
1180 Got error %d during COMMIT
1181 Got error %d during ROLLBACK
1182 Got error %d during FLUSH_LOGS
1183 Got error %d during CHECKPOINT
1184 Aborted connection %ld to db: '%s' user: '%s' host: `%s' (%s)
1185 The storage engine for the table does not support binary table dump
1186 Binlog closed, cannot RESET MASTER
1187 Failed rebuilding the index of dumped table '%s'
1188 Error from master: '%s'
1189 Net error reading from master
1190 Net error writing to master
1191 Can't find FULLTEXT index matching the column list
1192 Can't execute the given command because you have active locked tables or an active transaction
1193 Unknown system variable '%s'
1194 Table '%s' is marked as crashed and should be repaired
1195 Table '%s' is marked as crashed and last (automatic?) repair failed
1196 Some non-transactional changed tables couldn't be rolled back
1197 Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage. Increase this mysqld variable and try again
1198 This operation cannot be performed with a running slave, run STOP SLAVE first
1199 This operation requires a running slave, configure slave and do START SLAVE
1200 The server is not configured as slave, fix in config file or with CHANGE MASTER TO
1201 Could not initialize master info structure, more error messages can be found in the MySQL error log
1202 Could not create slave thread, check system resources
1203 User %s has already more than 'max_user_connections' active connections
1204 You may only use constant expressions with SET
1205 Lock wait timeout exceeded; Try restarting transaction
1206 The total number of locks exceeds the lock table size
1207 Update locks cannot be acquired during a READ UNCOMMITTED transaction
1208 DROP DATABASE not allowed while thread is holding global read lock
1209 CREATE DATABASE not allowed while thread is holding global read lock
1210 Wrong arguments to %s
1211 '%s'@'%s' is not allowed to create new users
1212 Incorrect table definition; all MERGE tables must be in the same database
1213 Deadlock found when trying to get lock; Try restarting transaction
1214 The used table type doesn't support FULLTEXT indexes
1215 Cannot add foreign key constraint
1216 Cannot add or update a child row: a foreign key constraint fails
1217 Cannot delete or update a parent row: a foreign key constraint fails
1218 Error connecting to master: %s
1219 Error running query on master: %s
1220 Error when executing command %s: %s
1221 Wrong usage of %s and %s
1222 The used SELECT statements have a different number of columns
1223 Can't execute the query because you have a conflicting read lock
1224 Mixing of transactional and non-transactional tables is disabled
1225 Option '%s' used twice in statement
1226 User '%s' has exceeded the '%s' resource (current value: %ld)
1227 Access denied. You need the %s privilege for this operation
1228 Variable '%s' is a LOCAL variable and can't be used with SET GLOBAL
1229 Variable '%s' is a GLOBAL variable and should be set with SET GLOBAL
1230 Variable '%s' doesn't have a default value
1231 Variable '%s' can't be set to the value of '%s'
1232 Wrong argument type to variable '%s'
1233 Variable '%s' can only be set, not read
1234 Wrong usage/placement of '%s'
1235 This version of MySQL doesn't yet support '%s'
1236 Got fatal error %d: '%s' from master when reading data from binary log
1237 Slave SQL thread ignored the query because of replicate-*-table rules
1238 Wrong foreign key definition for '%s': %s
1239 Key reference and table reference doesn't match
1240 Operand should contain %d column(s)
1241 Subquery returns more than 1 row
1242 Unknown prepared statement handler (%ld) given to %s
1243 Help database is corrupt or does not exist
1244 Cyclic reference on subqueries
1245 Converting column '%s' from %s to %s
1246 Reference '%s' not supported (%s)
1247 Every derived table must have it's own alias
1248 Select %u was reduced during optimisation
1249 Table '%s' from one of SELECT's can not be used in %s
1250 Client does not support authentication protocol requested by server; consider upgrading MySQL client
1251 All parts of a SPATIAL KEY must be NOT NULL
1252 COLLATION '%s' is not valid for CHARACTER SET '%s'
1253 Slave is already running
1254 Slave has already been stopped
1255 Too big size of uncompressed data. The maximum size is %d. (probably, length of uncompressed data was corrupted)
1256 ZLIB: Not enough memory available for zlib
1257 ZLIB: Not enough room in the output buffer for zlib (probably, length of uncompressed data was corrupted)
1258 ZLIB: Input data was corrupted for zlib
1259 %d line(s) was(were) cut by group_concat()
1260 Row %ld doesn't contain data for all columns
1261 Row %ld was truncated; It contained more data than there where input columns
1262 Data truncated, NULL supplied to NOT NULL column '%s' at row %ld
1263 Data truncated, out of range for column '%s' at row %ld
1264 Data truncated for column '%s' at row %ld
1265 Using storage engine %s for table '%s'
1266 Illegal mix of collations (%s,%s) and (%s,%s) for operation '%s'
1267 Can't drop one or more of the requested users
1268 Can't revoke all privileges, grant for one or more of the requested users
1269 Illegal mix of collations (%s,%s), (%s,%s), (%s,%s) for operation '%s'
1270 Illegal mix of collations for operation '%s'
1271 Variable '%s' is not a variable component (Can't be used as XXXX.variable_name)
1272 Unknown collation: '%s'
1273 SSL parameters in CHANGE MASTER are ignored because this MySQL slave was compiled without SSL support. They can be used later when MySQL slave with SSL will be started.
1274 Server is running in --secure-auth mode, but '%s@%s' has a password in the old format; please change the password to the new format
1275 Field or reference '%s%s%s%s%s' of SELECT #%d was resolved in SELECT #%d
1276 Wrong parameter or combination of parameters for START SLAVE UNTIL
1277 It is recommended to use --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL. Otherwise you will get problems if you get an unexpected slave's mysqld restart
1278 SQL thread is not to be started so UNTIL options are ignored
1279 Incorrect index name '%s'
1280 Incorrect catalog name '%s'
1281 Query cache failed to set size %lu, new query cache size is %lu
1282 Column '%s' cannot be part of FULLTEXT index
1283 Unknown key cache '%s'
1284 MySQL is started in --skip-name-resolve mode. You need to restart it without this switch for this grant to work
1285 Unknown table engine '%s'
1286 '%s' is deprecated. Use '%s' instead.
1287 The target table %s of the %s is not updatable.
1288 The '%s' feature was disabled. You need MySQL built with '%s' define to have it working
1289 MySQL is started in --skip-grant-tables mode. You can't use this command
1290 Can't create a %s from within another stored routine
1291 %s %s already exists
1292 %s %s does not exist
1293 Failed to DROP %s %s
1294 Failed to CREATE %s %s
1295 %s with no matching label: %s
1296 Redefining label %s
1297 End-label %s without match
1298 Referring to uninitialized variable %s
1299 SELECT in a stored procedure must have INTO
1300 RETURN is only allowed in a FUNCTION
1301 Statements like SELECT, INSERT, UPDATE (and others) are not allowed in a FUNCTION
1302 The update log is deprecated and replaced by the binary log. SET SQL_LOG_UPDATE has been ignored.
1303 The update log is deprecated and replaced by the binary log. SET SQL_LOG_UPDATE has been translated to SET SQL_LOG_BIN.
1304 Query execution was interrupted
1305 Wrong number of arguments for %s %s, expected %u, got %u
1306 Undefined CONDITION: %s
1307 No RETURN found in FUNCTION %s
1308 FUNCTION %s ended without RETURN
1309 Cursor statement must be a SELECT
1310 Cursor SELECT must not have INTO
1311 Undefined CURSOR: %s
1312 Cursor is already open
1313 Cursor is not open
1314 Undeclared variable: %s
1315 Wrong number of FETCH variables
1316 No data to FETCH
1317 Duplicate parameter: %s
1318 Duplicate variable: %s
1319 Duplicate condition: %s
1320 Duplicate cursor: %s
1321 Failed to ALTER %s %s
1322 Subselect value not supported

[출처] Mysql Error Code 정리|작성자 큐리

Posted by rainmaker4
2009.06.07 14:40
으흠.. 회사서 웹에디터(wyswyg)을 만들어 보라고 해서 이래저래 찾아보다가..
execCommand()에 관심을 가지게 되었다.
근데 IE 에서만 동작하는 지라.. 모질라 계열은 안되는 흠이 있었다.
알고보니 모질라 계열에서도 되는군..;;
좋은 자료인듯 해서 덥썩 물어왔다.
출처는 아래와 같다. 하앜..


IE execCommand() 의 명령어 목록 | JavaScript 태그::스크립트

2007/02/16 03:49

http://blog.naver.com/ohis26/20034027586

2D-Position 항상 드래그로 위치된 엘레멘트의 이동시킬 수 있다.
AbsolutePosition 엘레멘트의 위치(position)를 절대위치(absolute)로 설정한다.
BackColor 현재 선택의 배경색을 지정하거나 반환한다.
Bold 현재의 선책을 굵은 글자(bold)나 굵지않은 글자로 전환한다.
ClearAuthenticationCache 캐쉬(cache)의 모든 내용을 지운다. execCommand에서만 사용이 가능하다.
Copy 현재의 선택한 내용을 클립보드로 복사한다.
CreateBookmark 현재 선택이나 삽입 포인트의 anchor 혹은 북마크의 상대 이름 앤커로 북파크(bookmark)를 생성한다.
CreateLink 현재 선택에 주소 연결(hyperlink)을 삽입하거나, 주소를 입력하여 삽입할 수 있는 대화창을 열어준다.
Cut 현재의 선택한 내용을 클립보드로 복사하고 선택 내용을 지운다.
Delete 현재 선택을 삭제한다.
FontName 현재 선택의 글꼴을 지정하거나 반환한다.
FontSize 현재 선택의 글꼴 크기를 지정하거나 반환한다.
ForeColor 현재 선택의 글꼴 색상(foreground)을 지정하거나 반환한다.
FormatBlock 현재 블럭의 태그를 설정한다.
Indent 현재 선택 문자를 한 증가분 만큼 뒤로 들여쓰기 한다.
InsertButton 사용자나 메서드에 의하여 선택된 단추(button)의 보이는 내용을 삽입한다. selection 개체 createRange 메서드를 사용하여 선택한 문자를 반환하거나 설정할 수 있다.
InsertFieldset 문자 선택(text selection)의 박스를 삽입한다.
InsertHorizontalRule 문자 선택(text selection)의 수평선(HR)을 합입한다.
InsertIFrame 문자 선택(text selection)의 인라인 프레임(IFRAME)을 삽입한다.
InsertImage 문자 선택(text selection)의 이미지(IMAGE)를 삽입한다.
InsertInputButton 문자 선택(text selection)의 단추(BUTTON)를 삽입한다.
InsertInputCheckbox 문자 선택(text selection)의 체크박스(CHECKBOX)를 삽입한다.
InsertInputFileUpload 문자 선택(text selection)의 파일업로드(FileUpload)를 삽입한다.
InsertInputHidden 문자 선택(text selection)의 감춘단추(HIDDEN)를 삽입한다.
InsertInputImage 문자 선택(text selection)의 이미지(IMAGE) 제어를 덮어씌우기한다.
InsertInputPassword 문자 선택(text selection)의 암호(PASSWORD) 제어를 덮어씌우기한다.
InsertInputRadio 문자 선택(text selection)의 레디오단추(RADIO) 제어를 덮어씌우기한다.
InsertInputReset 문자 선택(text selection)의 재설정(RESET) 제어를 덮어씌우기한다.
InsertInputSubmit 문자 선택(text selection)의 송신(SUBMIT) 제어를 덮어씌우기한다.
InsertInputText 문자 선택(text selection)의 문자열입력(TEXT) 제어를 덮어씌우기한다..
InsertMarquee 문자 선택(text selection)의 빈 마퀴(MARQUEE)를 덮어씌우기한다..
InsertOrderedList 문자 선택(text selection)의 번호있는 목록(OL)과 보통 블럭간의 전환을 한다.
InsertParagraph 문자 선택(text selection)의 줄바꿈(BR)을 덮어씌우기한다.
InsertSelectDropdown 문자 선택(text selection)의 드롭다운 제어를 덮어씌우기한다.
InsertSelectListbox 문자 선택(text selection)의 목록박스 선택 제어를 덮어씌우기한다.
InsertTextArea 문자 선택(text selection)의 여러 줄 텍스트 입력 제어를 덮어씌운다..
InsertUnorderedList 문자 선택(text selection)을 번호있는 목록과 일반 블럭 양식을 서로 교차시킨다.
Italic 문자 선택(text selection)에서 이태릭(italic) 문자와 보통 문자간 전환한다.
JustifyCenter 문자 선택(text selection)이 위치한 불럭에서 중앙에 위치시킨다.
JustifyLeft 문자 선택(text selection)이 위치한 불럭에서 왼똑에 위치시킨다.
JustifyRight 문자 선택(text selection)이 위치한 불럭에서 오른쪽에 위치시킨다.
LiveResize 위치 변경과 크기 변경에 따라 업데이트 뿐 아니라, 과정 중 계속적으로 모양을 유지위하기 업데이트를 한다.
MultipleSelection 예를 들어 편집기의 이미지와 제어를 하나의 엘레멘트처럼, 한개 이상의 엘레멘트를 선택할 수 있게 허용한다. 지명적이거나 암시적으로 속성이 지정된 엘레멘트는 한번에 SHIFT 나 CTRL로 선택될 수 있다.
Outdent 문자 선택(text selection)의 현위치에서 들어쓰기 한 증가분 만큼 왼쪽으로 내어쓰기 한다.
OverWrite 문자 입력 방식과 덮어쒸우기 방식 사이를 전환한다.
Paste 문자 선택(text selection)을 클립보드 내용으로 덮어씌우기 한다.
Print 사용자가 편재의 문서를 인쇄할 수 있도록 인쇄 대화상자를 열어 준다.
Refresh 현재의 문서를 새로고침 한다..
RemoveFormat 현재 선택 문자로 부터 태그들을 제거한다.
SaveAs 현재의 문서를 파일로 저장한다.
SelectAll 전체 문서를 선택한다.
UnBookmark 현재의 선택으로부터 북마크의 어떤 내용을 삭제한다.
Underline 현재 선택 문자에서 밑줄 그어진 부분과 밑줄 없는 부분 사이를 전환한다.
Unlink 현재 선택 문자에서 모든 연결을 삭제한다.
Unselect 현재 선택 문자을 취소한다.

 

 

Mozilla execCommand() 명령어 목록


command value explanation / behavior
backcolor ???? This command will set the background color of the document.
bold none If there is no selection, the insertion point will set bold for subsequently typed characters.

If there is a selection and all of the characters are already bold, the bold will be removed.  Otherwise, all selected characters will become bold.
contentReadOnly true
false
This command will make the editor readonly (true) or editable (false).  Anticipated usage is for temporarily disabling input while something else is occurring elsewhere in the web page.
copy none If there is a selection, this command will copy the selection to the clipboard.  If there isn't a selection, nothing will happen.

note: this command won't work without setting a pref or using signed JS.  See: http://www.mozilla.org/editor/midasdemo/securityprefs.html

note:  the shortcut key will automatically trigger this command (typically accel-C) with or without the signed JS or any code on the page to handle it.
createlink url (href) This command will not do anything if no selection is made.  If there is a selection, a link will be inserted around the selection with the url parameter as the href of the link.
cut none If there is a selection, this command will copy the selection to the clipboard and remove the selection from the edit control.  If there isn't a selection, nothing will happen.

note: this command won't work without setting a pref or using signed JS.  See: http://www.mozilla.org/editor/midasdemo/securityprefs.html

note:  the shortcut key will automatically trigger this command (typically accel-X) with or without the signed JS or any code on the page to handle it.
decreasefontsize none This command will add a <small> tag around selection or at insertion point.
delete none This command will delete all text and objects that are selected.
fontname ???? This command will set the fontface for a selection or at the insertion point if there is no selection.
fontsize ???? This command will set the fontsize for a selection or at the insertion point if there is no selection.
forecolor ???? This command will set the text color of the selection or at the insertion point.
formatblock <h1>
<h2>
<h3>
<h4>
<h5>
<h6>
<pre>
<address>
<p>
p
[this list may not be complete]

heading <h1>
<h2>
<h3>
<h4>
<h5>
<h6>

hilitecolor ???? This command will set the hilite color of the selection or at the insertion point.  It only works with usecss enabled.
increasefontsize none This command will add a <big> tag around selection or at insertion point.
indent none Indent the block where the caret is located.
inserthorizontalrule none This command will insert a horizontal rule (line) at the insertion point.

Does it delete the selection?
inserthtml valid html string This command will insert the given html into the <body> in place of the current selection or at the caret location.
insertimage url (src) This command will insert an image (referenced by url) at the insertion point.

Does it delete the selection?
insertorderedlist none
insertunorderedlist none
insertparagraph none
italic none If there is no selection, the insertion point will set italic for subsequently typed characters.  

If there is a selection and all of the characters are already italic, the italic will be removed.  Otherwise, all selected characters will become italic.
justifycenter none
justifyfull none
justifyleft none
justifyright none
outdent none Outdent the block where the caret is located.  If the block is not indented prior to calling outdent, nothing will happen.

note:  is an error thrown if no outdenting is done?
paste none This command will paste the contents of the clipboard at the location of the caret.  If there is a selection, it will be deleted prior to the insertion of the clipboard's contents.

note: this command won't work without setting a pref or using signed JS.
user_pref("capability.policy.policynames", "allowclipboard"); user_pref("capability.policy.allowclipboard.Clipboard.paste", "allAccess");
See: http://www.mozilla.org/editor/midasdemo/securityprefs.html

note:  the shortcut key will automatically trigger this command (typically accel-V) with or without the signed JS or any code on the page to handle it.
redo none This command will redo the previous undo action.  If undo was not the most recent action, this command will have no effect.

note:  the shortcut key will automatically trigger this command (typically accel-shift-Z)
removeformat none
selectall none This command will select all of the contents within the editable area.

note:  the shortcut key will automatically trigger this command (typically accel-A)
strikethrough none If there is no selection, the insertion point will set strikethrough for subsequently typed characters.

If there is a selection and all of the characters are already striked, the strikethrough will be removed. Otherwise, all selected characters will have a line drawn through them.
styleWithCSS true
false
This command is used for toggling the format of generated content.  By default (at least today), this is true.  An example of the differences is that the "bold" command will generate <b> if the styleWithCSS command is false and generate css style attribute if the styleWithCSS command is true.
subscript none If there is no selection, the insertion point will set subscript for subsequently typed characters.  

If there is a selection and all of the characters are already subscripted, the subscript will be removed.  Otherwise, all selected characters will be drawn slightly lower than normal text.
superscript none If there is no selection, the insertion point will set superscript for subsequently typed characters.

If there is a selection and all of the characters are already superscripted, the superscript will be removed.  Otherwise, all selected characters will be drawn slightly higher than normal text.
underline none If there is no selection, the insertion point will set underline for subsequently typed characters.

If there is a selection and all of the characters are already underlined, the underline will be removed.  Otherwise, all selected characters will become underlined.
undo none This command will undo the previous action.  If no action has occurred in the document, then this command will have no effect.

note:  the shortcut key will automatically trigger this command (typically accel-Z)
unlink none

DEPRECATED COMMANDS
readonly true
false
This command has been replaced with contentReadOnly.  It takes the same values as contentReadOnly, but the meaning of true and false are inversed.
useCSS truefalse This command has been replaced with styleWithCSS.  It takes the same values as styleWithCSS, but the meaning of true and false are inversed.

출처 : Tong - hcomet님의 프로그래밍통

Posted by rainmaker4