语法错误 (操作符丢失) 在查询表达式 'ID=' 中。我劇烈的不知道是為什麽
ccdj 2004-05-05 08:04:42 下面的代碼。。出錯了.不知道什麽ID錯。。哎。搞得我頭都痛了
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access 驱动程序] 语法错误 (操作符丢失) 在查询表达式 'ID=' 中。
/2/admin_vipfuwuSave.asp, 行48
<!--#include file="function.asp"-->
<!--#include file="conn.asp"-->
<%
title=request.form("title")
Content=request.form("Content")
founerr=false
act=request("act")
set rs=server.createobject("adodb.recordset")
select case act
case "add"
call add()
case "edit"
call edit()
case "del"
call del()
case else
rs.close
conn.close
set conn=nothing
response.write "操作错误"
Response.End
end select
%>
<%
sub del()
sql="delete from vipfuwu where id="&request("id")
rs.open sql,conn,1,3
conn.close
set conn=nothing
response.redirect "admin_vipMana.asp"
end sub
sub add()
sql="select * from vipfuwu"
rs.open sql,conn,1,3
rs.addnew
rs("title")=title
rs("Content")=Content
rs("adddate")=NOW()
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
Response.Redirect "admin_vipMana.asp"
end sub
sub edit()
sql="select * from vipfuwu where ID="&request("ID")
rs.open sql,conn,1,3
rs("title")=title
rs("Content")=Content
rs("adddate")=NOW()
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
Response.Redirect "admin_vipMana.asp"
end sub
%>