Microsoft JET Database Engine 错误 '80040e14' 求教

Microsoft JET Database Engine 错误 '80040e14' 

语法错误 (操作符丢失) 在查询表达式 'student_college like '%%' and student_grade like'%%' and student_class like' 中。 

/manage/search.asp，行 152 


tflag=0
If exp_people<> "" Then 
  tflag=1
  tsql = "exp_people like '%"&exppeople&"%'"
end if
If student_college <> "请选择" Then
  if tflag=1 then
  tsql = tsql&" and "&"student_college like '%"&student_college&"%'"
  else 
  tflag=1
  tsql = "student_college like '%"&student_college&"%'" 
  end if
end if
If student_major <> "" Then
  if tflag=1 then
  tsql = tsql& " and "&"student_major like '%"&studentmajor&"%'"
  else 
  tflag=1
  tsql = "student_major like '%"&studentmajor&"%'"
  end if
end if
[color=#FF0000]If student_grade <> "请选择" Then
  if tflag=1 then
  tsql = tsql&" and "&"student_grade like'%"&student_grade&"%'"
  else 
  tflag=1
  tsql = "student_grade like '%"&student_grade&"%'"
  end if
end ifIf student_class <> "请选择" Then
  if tflag=1 then
  tsql = tsql&" and "&"student_class like "&student_class 
  else 
  tflag=1
  tsql = "student_class like '%"&student_class&"%'"
  end if
end if[/color]
set trs=server.CreateObject("adodb.recordset")
if tflag<>0 then
  tsql="select student_number from student where "&tsql
 

student_college studentmajor student_grade 这三个都没取到值啊

看下取值那是否出错了~