|
|
|
|
 |
|
채영이 / 2001-12-29 / 오후 5:33:28 / 203.255.3.190
조회수 : 152
|
| [질문] 미치겠다,,,구문에러 좀 해결해 주십시요.. |
> <%@ 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 요겁니다.
-----------------------------------------------------------
aim.mon이 아니고 aim, mon 아닌가요?
|
|
|
|