뿌려주는 부분소스...
<%
vcName = Request("vcName")
vcZipCode = Request("vcZipCode1") & "-" &
Request("vcZipCode2")
vcAddress = Request("vcAddress1") & " " &
Request("vcAddress2")
vcEmail = Request("vcEmail")
vcTelNo = Request("vcTelNo1") & "-" & Request("vcTelNo2")
& "-" & Request("vcTelNo3")
cResearchCode = Request("cResearchCode")
result = Request("result")
SQL = " INSERT INTO tbJapanPollUser ( vcName, vcZipCode,
vcAddress, vcEmail, cResult, dtRegDate, vcTelNo, cResearchCode )
Values ('"
SQL = SQL & vcName & "','" & vcZipCode & "','"
& vcAddress & "','" & vcEmail & "','" & result
& "',' GetDate() ','" & vcTelNo & "','" &
cResearchCode & "')"
Conn.Execute(SQL)
Conn.close
Set Conn = Nothing
%>
----------------------
실행시의 에러 코드....
Microsoft OLE DB Provider for SQL Server error '80040e07'
varchar 값 '011-1212-111'을(를) int
데이터 형식의 열로 변환하는 중 구문 오류가 발생했습니다.
/japan/SubMitOK.asp, line
16
--------------------------
|