|
|
|
|
 |
|
이쁜이 / 2000-05-22 / 오전 9:52:31 / 203.248.144.11
조회수 : 117
|
| [질문] 머리글오류에 관한 재질문....x); |
c_insert.asp
<%response.buffer = true%>
<%
Set DbCon = Server.CreateObject("ADODB.Connection")
DbCon.Open ("DSN=ASP;UID=sa;PWD=;")
SQLString = "SELECT MAX(no) FROM asptable"
Set Result = DbCon.Execute( SQLString )
MaxNO = Result(0) + 1
subject = Request("subject")
subject = Replace(subject, "'","''")
If subject="" Then
session("msg")="제목 않썼네요... ^^;"
Redirect
End If
writer = Request("writer")
If writer="" Then
session("msg")="이름 않쓰면 누가 썼는지 모르지요!"
Redirect
End If
content = Replace(Request("content"), "'","''")
If content ="" Then
session("msg")="내용을 써야지요? 땍..."
Redirect
End If
email= Request("email")
If email ="" Then
email = " "
End If
passwd = Request("passwd")
If passwd ="" Then
passwd = " "
End If
sql="INSERT INTO asptable (no,subject,writer,email,visited,date,passwd,content)"
sql=sql &"values ("& MaxNO & ",'"
sql=sql & subject &"','"
sql=sql & writer &"','"
sql=sql & email &"',0,'"
sql=sql & date &"','"
sql=sql & passwd &"','"
sql=sql & content &"')"
Set Result = DbCon.Execute(sql)
DbCon.Close
Response.Redirect "c_InsertResult.htm"
%>
맨위에 내용처럼 <%response.buffer =true%>라고 했는데 역시 똑같은 error message가 나와 source를 올립니다....
빠른 답변 부탁드립니다...
|
|
|
|