ASP中SQL数据表insert后，表中无内容，求助！

来源：百度知道 编辑：UC知道 时间：2024/05/11 00:31:20
以下是我的代码：
＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
<!--#include file="conn.asp"-->
<%
dim zhangname,jiename,pointname,ndxsname
dim zid,pid,jid,ndxs

'从Web页获取章、节、知识点、难度的值
zhangname=trim(request.form("zhangname"))
jiename=trim(request.form("jiename"))
pointname=trim(request.form("pointname"))
ndxsname=trim(request.form("ndxsname"))

set rs=conn.execute("select realnum from zjpindex where zhangname like '%"&trim(zhangname)&"%'")
zid=rs("realnum")
set rs=conn.execute("select realnum from zjpindex where jiename like '%"&trim(jiename)&"%'")
jid=rs("realnum")
set rs=conn.execute("select realnum from zjpindex where pointname like '%"&trim(pointname)&"%'")
pid=rs("realnum")
set rs=conn.execute("select id from ndxs where ndxs like &

set rs=conn.execute("insert into rtemp (tmname) select tmname from rightorwrong where ndxs like '%"&trim(ndxs)&"%' and point like '%"&trim(point)&"%'")

set rs=conn.execute("insert into rtemp (tmname) select tmname, from rightorwrong where ndxs like '%"&trim(ndxs)&"%' and point like '%"&trim(point)&"%'")

这句多了个逗号,

我只回答你随便做的测试，set rs=conn.execute("insert into rtemp (tmname) values(abc)") ，这句之所以没有插进去，是因为abc没有加单引号。

什么数据库？？如果是access的话，那么检查你这个数据库的文件权限