===============================================================
<!-- #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
====================================================================
아무리 봐도 틀린곳을 못찾겠는데.. 어케된 일인지.. ㅜ,ㅠ
<!-- #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
====================================================================
아무리 봐도 틀린곳을 못찾겠는데.. 어케된 일인지.. ㅜ,ㅠ
다음검색