인터페이스 넘 구리다..: 9월 2009

2009년 9월 25일 금요일

relay check

http://www.antispam-ufrj.pads.ufrj.br

2009년 9월 21일 월요일

연결된서버 ANSI_NULLS 및 ANSI_WARNINGS 옵션문제

-----------------------------------------------------------------------------------------

오류 7405: 유형이 다른 쿼리를 사용하려면 연결에 대해 ANSI_NULLS 및 ANSI_WARNINGS 옵션을
설정해야 합니다. 이렇게 하면 일관된 방식으로 쿼리를 사용할 수 있습니다. 이 옵션을 설정한 다음
쿼리를 다시 실행하십시오
-----------------------------------------------------------------------------------------

두 서버간의 옵션이 달라 발생하는 문제.

CREATE PROC 구문전에 아래 구문을 먼저 적는다.

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
GO

CREATE PROC SP_XXX
AS

서버자체 옵션을 변경

EM에서 서버선택--> 속성 --> 옵션 -->설정

설정에서 ANSI NULL 하구 ANSI WARNING 설정변경

[MS-SQL] DATETIME 변환

0	Feb 22 2006 4:26PM	CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0)
1	02/22/06	CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1)
2	06.02.22	CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2)
3	22/02/06	CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3)
4	22.02.06	CONVERT(CHAR(8), CURRENT_TIMESTAMP, 4)
5	22-02-06	CONVERT(CHAR(8), CURRENT_TIMESTAMP, 5)
6	22 Feb 06	CONVERT(CHAR(9), CURRENT_TIMESTAMP, 6)
7	Feb 22, 06	CONVERT(CHAR(10), CURRENT_TIMESTAMP, 7)
8	16:26:08	CONVERT(CHAR(8), CURRENT_TIMESTAMP, 8)
9	Feb 22 2006 4:26:08:020PM	CONVERT(CHAR(26), CURRENT_TIMESTAMP, 9)
10	02-22-06	CONVERT(CHAR(8), CURRENT_TIMESTAMP, 10)
11	06/02/22	CONVERT(CHAR(8), CURRENT_TIMESTAMP, 11)
12	060222	CONVERT(CHAR(6), CURRENT_TIMESTAMP, 12)
13	22 Feb 2006 16:26:08:020	CONVERT(CHAR(24), CURRENT_TIMESTAMP, 13)
14	16:26:08:037	CONVERT(CHAR(12), CURRENT_TIMESTAMP, 14)
20	2006-02-22 16:26:08	CONVERT(CHAR(19), CURRENT_TIMESTAMP, 20)
21	2006-02-22 16:26:08.037	CONVERT(CHAR(23), CURRENT_TIMESTAMP, 21)
22	02/22/06 4:26:08 PM	CONVERT(CHAR(20), CURRENT_TIMESTAMP, 22)
23	2006-02-22	CONVERT(CHAR(10), CURRENT_TIMESTAMP, 23)
24	16:26:08	CONVERT(CHAR(8), CURRENT_TIMESTAMP, 24)
25	2006-02-22 16:26:08.037	CONVERT(CHAR(23), CURRENT_TIMESTAMP, 25)
100	Feb 22 2006 4:26PM	CONVERT(CHAR(19), CURRENT_TIMESTAMP, 100)
101	02/22/2006	CONVERT(CHAR(10), CURRENT_TIMESTAMP, 101)
102	2006.02.22	CONVERT(CHAR(10), CURRENT_TIMESTAMP, 102)
103	22/02/2006	CONVERT(CHAR(10), CURRENT_TIMESTAMP, 103)
104	22.02.2006	CONVERT(CHAR(10), CURRENT_TIMESTAMP, 104)
105	22-02-2006	CONVERT(CHAR(10), CURRENT_TIMESTAMP, 105)
106	22 Feb 2006	CONVERT(CHAR(11), CURRENT_TIMESTAMP, 106)
107	Feb 22, 2006	CONVERT(CHAR(12), CURRENT_TIMESTAMP, 107)
108	16:26:08	CONVERT(CHAR(8), CURRENT_TIMESTAMP, 108)
109	Feb 22 2006 4:26:08:067PM	CONVERT(CHAR(26), CURRENT_TIMESTAMP, 109)
110	02-22-2006	CONVERT(CHAR(10), CURRENT_TIMESTAMP, 110)
111	2006/02/22	CONVERT(CHAR(10), CURRENT_TIMESTAMP, 111)
112	20060222	CONVERT(CHAR(8), CURRENT_TIMESTAMP, 112)
113	22 Feb 2006 16:26:08:067	CONVERT(CHAR(24), CURRENT_TIMESTAMP, 113)
114	16:26:08:067	CONVERT(CHAR(12), CURRENT_TIMESTAMP, 114)
120	2006-02-22 16:26:08	CONVERT(CHAR(19), CURRENT_TIMESTAMP, 120)
121	2006-02-22 16:26:08.080	CONVERT(CHAR(23), CURRENT_TIMESTAMP, 121)
126	2006-02-22T16:26:08.080	CONVERT(CHAR(23), CURRENT_TIMESTAMP, 126)
127	2006-02-22T16:26:08.080	CONVERT(CHAR(23), CURRENT_TIMESTAMP, 127)
130	24 ???? 1427 4:26:08:080PM	CONVERT(CHAR(32), CURRENT_TIMESTAMP, 130)
131	24/01/1427 4:26:08:080PM	CONVERT(CHAR(25), CURRENT_TIMESTAMP, 131) 출처:[MS-SQL] DATETIME 변환

2009년 9월 8일 화요일

responseText 결과내 스크립트

responseText

----------------------------------------------

alert('TEST');

</script>

----------------------------------------------

function result_insert(responseText)

{

var res = "<body>" + responseText.replace(/<\/?head>/gi, "").replace(/<\/?html>/gi, "").replace(/<body/gi, "<div").replace(/<\/body/gi, "</div") + "</body>";

document.all.result.innerHTML = res;

var scripts = document.all.result.getElementsByTagName("script");

if(scripts == false) return true;

for(var i=0; i<scripts.length; i++)

{
var scriptclone = document.createElement("script");
if(scripts[i].attributes.length > 0)

{

for(var j in scripts[i].attributes)

{
if(typeof(scripts[i].attributes[j]) != "undefined"
&& typeof(scripts[i].attributes[j].nodeName) != "undefined"

&& scripts[i].attributes[j].nodeValue != null
&& scripts[i].attributes[j].nodeValue != "")
{
scriptclone.setAttribute(scripts[i].attributes[j].nodeName, scripts[i].attributes[j].nodeValue);
}
}
}
scriptclone.text = scripts[i].text;

if (navigator.userAgent.indexOf("Opera")>0) {return;}
scripts[i].parentNode.replaceChild(scriptclone, scripts[i]);
}
return true;

}

2009년 9월 2일 수요일

Random Query

Oracle

SELECT * FROM emp SAMPLE(5)

MSSQL

SELECT TOP 5 * FROM emp ORDER BY NEWID()

MySQL

SELECT * FROM emp ORDER BY RAND() LIMIT 0, 5