UC知道asp 删除记录的问题
来源：百度知道 编辑：UC知道 时间：2024/05/19 09:20:38
如下应该如何修改？
<input type="button" name="action" value="删除" onclick="inks.asp?action=del_links';">
if action="add_links" then
call add_links()
end if
if action="del_links" then
delid=replace(request("id")," ","")
call del_links()
end if
if action="删除" then
dellinksid=replace(request("linksid"),"'","")
call del_links()
end if
sub del_links()
if dellinksid="" or isnull(dellinksid) then
response.write "<script language='javascript'>"
response.write "alert('出错了，您什么也没有选择！');"
response.write "location.href='links.asp';"
response.write "</script>"
response.end
else
conn.execute("delete from
<input type="button" name="action" value="删除" onclick="inks.asp?action=del_links';">
if action="add_links" then
call add_links()
end if
if action="del_links" then
delid=replace(request("id")," ","")
call del_links()
end if
if action="删除" then
dellinksid=replace(request("linksid"),"'","")
call del_links()
end if
sub del_links()
if dellinksid="" or isnull(dellinksid) then
response.write "<script language='javascript'>"
response.write "alert('出错了，您什么也没有选择！');"
response.write "location.href='links.asp';"
response.write "</script>"
response.end
else
conn.execute("delete from
急!ASP删除记录的问题!急急急!
悬赏分：0 - 解决时间：2007-5-14 20:04
ASP删除Access中记录的问题:
<%
Dim UN
Dim sql
UN=Request.QueryString("Name")
set ado1=Server.CreateObject("ADODB.connection")
ado1.connectionString="Provider=microsoft.JET.OLEDB.4.0;Data Source="+server.MapPath("db1.mdb")
ado1.open
sql="delete from usertable where ID='" + trim(request.querystring("ID")) + "'"
ado1.Execute SQL
Response.Redirect "index.asp?word=已经成功删除了用户"+UN
%>
因为ID是自动编号的,在运行的时候出现了"标准表达式中数据类型不匹配",请问如何修改才能不出现这个问题?
改成
sql="delete from usertable where ID=" + trim(request.querystring("ID")) + "" 也不行,出现语法错误 (操作符丢失) 在查询表达式 'ID=' 中
谢谢大家啦!
本人有急用!
问题补充：放到sql="delete from usertable where ID=" + trim(request.querystring("ID"))
的后面是没问题,放到ado1.Execute sql后面