CAFE

ASP Q/A

질문 다시 올립니다.. insert into 문의 구문 오류라는데요..

작성자dazzi|작성시간02.06.11|조회수71 목록 댓글 0
===============================================================
<!-- #include file="../sessionCheck.inc" -->
<!-- #include file="../dbopen.inc" -->
<%
indexNum = request("indexNum")
title = request("title")
position = request("position")
year1 = request("year1")
month1 = request("month1")
day1 = request("day1")
startHour = request("startHour")
startMinute = request("startMinute")
endHour = request("endHour")
endMinute = request("endMinute")
content = request("content")
id = session("id")

'response.write request("indexNum") &"<br>"
'response.write title &"<br>"
'response.write position &"<br>"
'response.write year1 &"<br>"
'response.write month1 &"<br>"
'response.write day1 &"<br>"
'response.write startHour &"<br>"
'response.write startMinute &"<br>"
'response.write endHour &"<br>"
'response.write endMinute &"<br>"
'response.write content &"<br>"
'response.write session("id") &"<br>"

startTime = startHour & ":" & startMinute
endTime = endHour & ":" & endMinute

sql = "update calendar set title='" & title
sql = sql & "', position='" & position
sql = sql & "', startTime='" & startTime
sql = sql & "', endTime='" & endTime
sql = sql & "', content='" & content
sql = sql & "' where indexNum=" & indexNum
'response.write sql
db.execute sql
%>
<script language="javascript">
alert(‎"스케줄이 수정되었습니다.\n\n일정관리 메인 페이지로 이동합니다.");
location.href="main.asp";
</script>
================================================================

Microsoft JET Database Engine (0x80040E14)
INSERT INTO 문의 구문 오류입니다.
/study/report/dbreport/iljung/iljung/joinOk.asp, line 31
====================================================================

아무리 봐도 틀린곳을 못찾겠는데.. 어케된 일인지.. ㅜ,ㅠ
다음검색
현재 게시글 추가 기능 열기

댓글

댓글 리스트
맨위로

카페 검색

카페 검색어 입력폼