티스토리 뷰
MS-SQL는 TEXT가 있어서 괜찮은데, ORACLE은 4000자가 제한이라서;;;
INSERT
시퀀시 가져오기
sql = "select SQ_SEQ.nextval as seq from dual"
Set rs = conn.Execute(sql)
seq= rs("seq")
rs.Close
' INSERT 하기전 DB 초기화: empty_clob()
strSQL = "INSERT INTO MAILING_SP_TAB (SEQ, CONTENT) VALUES (" & SEQ & " & empty_clob())"
conn.Execute(strSQL)
' UPDATE
strSQL = "update 테이블 이름 set CONTENT=? where SEQ=?"
Set cmd = Server.CreateObject("ADODB.Command")
With cmd
.ActiveConnection = conn
.CommandType = adCmdText
.CommandText = strSQL
.Parameters.Append .CreateParameter("@CONTENT", adLongVarChar, adParamInput, lenB(CONTENT), CONTENT)
.Parameters.Append .CreateParameter("@SEQ", adInteger, adParamInput, , SEQ)
.Execute
End With
내용 보기
qr = "select NVL(dbms_lob.getlength(SP_MEMBER),0) as CLOBLength from MAILING_SP_TAB where SEQ="&seq
rs.open qr, conn
ClobLength = CLng(trim(rs("CLOBLength")))
rs.close
VIEW
'내용 가져오기
Dim packet_size, packet_count
packet_size = 3000
If ClobLength Mod packet_size = 0 Then
packet_count = ClobLength/packet_size
Else
packet_count = ClobLength/packet_size + 1
End If
qr = "SELECT seq, groupnm, enroll_id "
For i = 1 To packet_count
qr = qr & ", dbms_lob.substr(SP_MEMBER, 3000, " & ((i-1)*packet_size + 1) & ") as group_sp "
Next
qr = qr & "FROM MAILING_SP_TAB WHERE SEQ = " & seq
rs.open qr, conn
if not rs.eof then
For c = 1 To rs.Fields.count - 1
qr = qr & rs(c)
Next
seq = trim(rs("seq"))
groupnm = trim(rs("groupnm"))
Bgroupnm = trim(rs("groupnm"))
enroll_id = trim(rs("enroll_id"))
gMember = replace(trim(rs("group_sp")),"""","'")
else
response.write "<script type=""text/javascript"">" &_
"alert (""필수값이 전송되지 않았습니다."");" &_
"history.go(-2);" &_
"</script>"
end if
- Total
- Today
- Yesterday
- Git
- ASP.NET
- HttpCookie
- case
- Visual Stuiod Team Services
- 폰트색상
- .NET Core
- SQL
- 문자열 분리
- UTF-8
- 영어
- 오라클
- Convert
- c#
- pang caching
- Windows2003
- index
- IIS
- 숙취
- injection
- offline application cache
- ADO
- gitignore
- asp
- jquery
- SEQUENCE
- MS-SQL
- 암호화
- 인덱스
- oracle
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | |
7 | 8 | 9 | 10 | 11 | 12 | 13 |
14 | 15 | 16 | 17 | 18 | 19 | 20 |
21 | 22 | 23 | 24 | 25 | 26 | 27 |
28 | 29 | 30 |