sql="select tbtk.tmid,tbtk.title,tbkc.kcm,tbtk.category,tbtk.chapter,tbtk.kao,tbtk.level from tbtk,tbkc  where tbtk.kcid=tbkc.kcid  and tbkc.addname = "& request.cookies("username") &"  and tbkc.kcid = "& subjectview &" and category="&typeadd &" order by tbtk.chapter,category,tbtk.tmid desc"
sql="select tbtk.tmid,tbtk.title,tbkc.kcm,tbtk.category,tbtk.chapter,tbtk.kao,tbtk.level from tbtk,tbkc  where tbtk.kcid=tbkc.kcid  and tbkc.addname = "& session("adminname") &"  and tbkc.kcid = "& subjectview &" and category="&typeadd &" order by tbtk.chapter,category,tbtk.tmid desc"
不管是那一句都报错，是什么地方写错了吗？

精简 排除法

sql="select tbtk.tmid,tbtk.title,tbkc.kcm,tbtk.category,tbtk.chapter,tbtk.kao,tbtk.level from tbtk,tbkc  where tbtk.kcid=tbkc.kcid  and  tbkc.kcid = "& subjectview &" and category="&typeadd &" order by tbtk.chapter,category,tbtk.tmid desc"
这样时正确
tbtk=request.cookies("username")是我后来添上的，就不对了。是不是语法有错误？

tbkc.addname = '"& request.cookies("username") &"'

应该这样？

所有涉及文本型字段的条件判断应由
tbkc.addname = "& request.cookies("username") &"
改为
tbkc.addname = '"& request.cookies("username") &"'