|
|
|
|
 |
|
박가루 / 2001-12-29 / 오후 4:52:47 / 210.178.30.238
조회수 : 137
|
| [질문] 미치겠다,,,구문에러 좀 해결해 주십시요.. |
<%@ Language=VBScript %>
<%
if Request("IsWrite") = "TRUE" then
set dbCon = Server.CreateObject("ADODB.Connection")
dbCon.Open "health", "", ""
dbCon.Execute "INSERT INTO salyung(from,grade,name,aim.mon,tue,wed,thu,fri,sat,sun) VALUES ('" & _
Request("from") & "', '" & _
Request("grade") & "', '" & _
Request("name") & "', '" & _
Request("aim") & "', '" & _
Request("mon") & "', '" & _
Request("tue") & "', '" & _
Request("wed") & "', '" & _
Request("thu") & "', '" & _
Request("fri") & "', '" & _
Request("sat") & "', '" & _
Request("sun") & "')"
Response.redirect "List.asp"
end if
%>
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=ks_c_5601-1987">
<meta name="GENERATOR"
content="Microsoft FrontPage (Visual InterDev Edition) 2.0">
<title>글 올리기</title>
</head>
<body bgcolor="#ffffff">
<h1>글 올리기</h1>
<hr>
<form action="write.asp" method="post">
<table border="1" cellpadding="6" cellspacing="0">
<tr>
<td align="middle" bgcolor="#e2f1fe">소속</td>
<td><input name="from" ></td>
<td align="middle" bgcolor="#e2f1fe" colspan="2">계급</td>
<td><input name="grade" ></td>
</tr>
<tr> <td align="middle" bgcolor="#e2f1fe">성명</td>
<td><input name="name" ></td>
<td align="middle" bgcolor="#e2f1fe" colspan="2">목표량</td>
<td><input name="aim" ></td>
</tr>
<tr> <td align="middle" bgcolor="#e2f1fe">월요일</td>
<td><input name="mon" ></td>
<td align="middle" bgcolor="#e2f1fe" colspan="2">화요일</td>
<td><input name="tue" ></td>
</tr></TR>
<tr> <td align="middle" bgcolor="#e2f1fe">수요일</td>
<td><input name="wed" ></td>
<td align="middle" bgcolor="#e2f1fe" colspan="2">목요일</td>
<td><input name="thu" ></td>
</tr>
<tr> <td align="middle" bgcolor="#e2f1fe">금요일</td>
<td><input name="fri" ></td>
<td align="middle" bgcolor="#e2f1fe" colspan="2">토요일</td>
<td><input name="sat" ></td>
</tr>
<tr> <td align="middle" bgcolor="#e2f1fe">일요일</td>
<td><input name="sun" ></td>
<td align="middle" bgcolor="#e2f1fe" colspan="2"></td>
<td></td>
</tr>
</table>
<p>
<input type="submit" name="cmdOK" value="확인">
<input type="reset" name="cmdReset" value="초기화">
<input type="hidden" name="IsWrite" value="TRUE">
</p>
</form>
</body>
</html>
############################################
이렇게 소스를 작성하고 페이지를 읽어들이면,
처음에 입력창 떳다가 확인 눌러서 보내면
7번째 줄의 INSERT구문의 구문에러라고 자꾸 뜨네요...
이거 땜에 2시간 동안 헤메고 있습니다...
수정 좀 해주십시요...
% DSN이름은 health이고 테이블 이름은 salyung 요겁니다. |
|
|
|