아주 신생아 초보라 너무 어렵네요 ㅠ
기존에 짜여져 있던것들 복사해서
게시판에 입력한 내용들을
수정할 수 있게 해야하는데
Microsoft OLE DB Provider for SQL Server 오류 '80040e14'
'=' 근처의 구문이 잘못되었습니다.
/cs/redit_ok-test.asp, 줄 23
위와 같은 오류가 나서 찾아보려는데 도무지 뭐가 문제인지 모르겠습니다..
한번 봐주시면 감사하겠습니다!
<%
dim qtitle,qcont,uregion,oneone1,idx,intpg,strPart,strSearch
strPart = Request.Form("strPart")
strSearch = Request.Form("strSearch")
qtitle = Request.Form("qtitle")
qcont = Request.Form("qcont")
uregion = Request.Form("uregion")
oneone1 = Request.Form("oneone1")
If Len(oneone1) = 0 Then oneone1 = 0
qtitle = Tag2Txt(qtitle)
qcont = Replace(qcont,"'","''")
uregion = Tag2Txt(uregion)
idx = request.Form("idx")
intpg = request.Form("intpg")
dim sql
sql = "update oneone1 set oneone1=" & oneone1 & ",qtitle='" & qtitle & "',qcont='" & qcont & "',uregion='" &
uregion & "' where qidx=" & idx
db.execute(sql)
db.close
set db = nothing
response.redirect "rneyong.asp?idx=" & qidx & "&intpg=" & intpg &"&strPart="& strPart &"&strSearch="&
strSearch &""
Response.end
Function Tag2Txt(s)
s = Replace(s,"'","''")
s = Replace(s,"<","<")
s = Replace(s,">",">")
s = Replace(s,"&","&")
Tag2Txt = s
End Function
%>
<form name="wform" action="redit_ok-test.asp" method="post" enctype="multipart/form-data"
style="display:inline;">
<div class="meminfo">
<div class="mem_line">
<div class="mem_tit">제목</div>
<div class="txt write_tit"><input type="text" name="qtitle" maxlength="255" value="
<%=qtitle%>"></div>
</div>
<div class="mem_line">
<div class="mem_tit">성명 / 생년월일</div>
<div class="txt"><span class="mem-name"><%=name%></span> /
<span class="mem-age"><%=juminno1%></span></div>
</div>
<div class="mem_line">
<div class="mem_tit">연락처</div>
<div class="txt">
<span class="utel"><%=tel2%></span>
</div>
</div>
<div class="mem_line">
<div class="mem_tit">거주 지역</div>
<div class="txt"><input type="text" name="uregion" maxlength="15" value="
<%=uregion%>"></div>
</div>
<div class="mem_line">
<div class="mem_tit" style="height: 320px;">자기 소개</div>
<div class="txt">
<textarea cols="50" name="qcont" id="neyong" ><%=qcont%></textarea>
</div>
</div>
</form>