请给看看下面语句有什么问题，谢谢 - 编程论坛

#2

jingjing3162009-10-13 14:38

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"
不管是那一句都报错，是什么地方写错了吗？

#3

aspic2009-10-13 14:41

精简排除法

#4

jingjing3162009-10-13 14:45

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")是我后来添上的，就不对了。是不是语法有错误？

#5

aspic2009-10-13 14:54

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

应该这样？

#6

chenguoxing5172009-10-13 15:26

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