===============================================================================
Dim strSQL, DBConn, strConnect
strSQL = "INSERT INTO APMS_USR_WEB ("
strSQL = strSQL & "WEB_ID,WEB_PASS,WEB_NAME,"
strSQL = strSQL & "WEB_RNUM1,WEB_RNUM2,WEB_PNUM1,"
strSQL = strSQL & "WEB_PNUM2,WEB_ADDR1,WEB_ADDR2,"
strSQL = strSQL & "WEB_POST,WEB_DEPT,WEB_CLASS,WEB_TEL,"
strSQL = strSQL &
"WEB_CEL,WEB_EMAIL,WEB_DATE,POWER_ID,WEB_IP)"
strSQL = strSQL & " VALUES ('"& web_id &"','"&
web_pass &"',"
strSQL = strSQL & "'"& web_name &"','"& web_rnum1
&"','"& web_rnum2 &"',"
strSQL = strSQL & "'"& web_pnum1 &"','"& web_pnum2
&"','"& web_addr1 &"',"
strSQL = strSQL & "'"& web_addr2 &"','"& web_post
&"','"& web_dept &"',"
strSQL = strSQL & "'"& web_class &"','"& web_tel
&"','"& web_cel &"',"
strSQL = strSQL & "'"& web_email &"','"& web_date
&"','"& web_power &"','127.0.0.1');"
Set DBConn = Server.CreateObject("ADODB.Connection")
strConnect = "Provider=MSDAORA.1;Password=XXXX;User
ID=XXXX;Data Source=XXXX;Persist Security Info=True"
DBConn.open strConnect
DBConn.Execute strSQL
DBConn.Close
Set DBConn = nothing
===============================================================================
저기 소스중에 ...
DBConn.Execute strSQL <-- 이줄에서 ORA-00911: 문자가
부적합합니다 에러메세지가 뜹니다.
strSQL 문자길이가 너무 길어서 그런가요?
Insert문을 직접 디비에 쳐보면,,,제대로 insert 되던대...
Execute 하는 곳에서 자꾸 에러가 나네요.
|