|
|
|
|
ÀÌ»ÛÀÌ / 2000-05-22 / ¿ÀÈÄ 4:31:15 / 203.248.144.11
Á¶È¸¼ö : 121
|
[Áú¹®] ¸Ó¸®±Û¿À·ù ¿©ÀüÈ÷ °¥ÇǸ¦ ¸øÀâÀ½ |
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")="Á¦¸ñ ¾Ê½è³×¿ä... ^^;"
Response.Redirect "c_preinsert.htm"
Response.close
End If
writer = Request("writer")
If writer="" Then
session("msg")="À̸§ ¾Ê¾²¸é ´©°¡ ½è´ÂÁö ¸ð¸£Áö¿ä!"
Response.Redirect "c_preinsert.htm"
Response.close
End If
content = Replace(Request("content"), "'","''")
If content ="" Then
session("msg")="³»¿ëÀ» ½á¾ßÁö¿ä? ¶¨..."
Response.Redirect "c_preinsert.htm"
Response.close
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"
%>
c_insert.asp
ÀÀ´ä °³Ã¼ error 'ASP 0156'
¸Ó¸®±Û ¿À·ù
/kosco/c_insert.asp, line 3
Ŭ¶óÀ̾ðÆ® ºê¶ó¿ìÀú¿¡ HTTP Çì´õ°¡ ÀÌ¹Ì ¾²¿© ÀÖ½À´Ï´Ù. HTTP Çì´õ´Â ÆäÀÌÁö ³»¿ëÀ» ¾²±â Àü¿¡¸¸ ¼öÁ¤ÇØ¾ß ÇÕ´Ï´Ù.
¿©ÀüÈ÷ ¿À·ù¹ß»ý!!
Á¦°¡ asp ¿ÕÃʺ¸¶ó¼ ÀüÇô °¥ÇǸ¦ ÀâÁö¸øÇÏ°í ÀÖ½À´Ï´Ù.
source¸¦ º¸½Ã°í ÁöÀûÇØÁÖ¼¼¿ä!!
¹Ù¸¥ ÇØ´äÀ» ±â´Ù¸®¸ç...
|
|
|
|