|
|
|
|
 |
|
food / 2000-11-10 / 오전 11:12:09 / 210.219.185.189
조회수 : 130
|
| [질문] 게시판에러에요 알려주세요< |
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string.
/mytest/board_re/write_ok.asp, line 67
소스는 이거입니다
<%
'request객체를 통해 넘어온 값들을 변수에 저장한다. (추천되는 방법이다)
name = request("name")
email = request("email")
homepage = request("homepage")
title = request("title")
pwd = request("pwd")
content = request("content")
'쿼리에 '가 들어가면 에러가 나기에 그것을 replace 처리해준다.
title = replace(title,"'","''")
content = replace(content,"'","''")
Set db = Server.CreateObject("ADODB.Connection")
db.Open("DSN=sql;UID=sa;PWD=;")
SQL = "Select Max(num) from Board_Re"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open SQL, db
If IsNULL(rs(0)) Then
number = 1
else
number = rs(0) + 1
End If
'**************답변형 게시판에서의 추가부분**********************'
if request("idx") <> "" then '즉 답변쓰기라면
ref = Cint(request("ref"))
re_step = CInt(Request("re_step"))
re_level = CInt(Request("re_level"))
SQLString = "UPDATE Board_Re SET re_step = re_step + 1 WHERE ref=" & ref & " AND re_step > " & re_step
db.Execute(SQLString)
re_step = re_step + 1
re_level = re_level + 1
else ' 첨 글쓰기라면...
ref = number
re_step=0
re_level=0
end if
'************************************************'
SQL = "INSERT INTO Board_Re (name,email,homepage,title,content,num,"
SQL = SQL & "readnum,writeday,ref,re_level,re_step,pwd) VALUES "
SQL = SQL & "('" & name & "'"
SQL = SQL & ",'" & email & "'"
SQL = SQL & ",'" & homepage & "'"
SQL = SQL & ",'" & title & "'"
SQL = SQL & ",'" & content & "'"
SQL = SQL & "," & number
SQL = SQL & ", 0 ,'" & now() &"'"
SQL = SQL & "," & ref
SQL = SQL & "," & re_level
SQL = SQL & "," & re_step
SQL = SQL & ",'" & pwd & "')"
'Response.Write sql
db.Execute SQL (이부분 에서에러입니다.67번째)
rs.Close
db.close
Set rs = Nothing
Set db = Nothing
Response.redirect "list.asp"
%>
|
|
|
|