请大家帮忙看看这个sql语句错在那里?????
wp.execute( "select   name   from   courseevaluation   where   classid= "   &   ClassID   & "   and     username= ' "   &   EvaluationUserNum   &   " ' "   &   "   and   section= ' "&   EvaluationSection   & " ' ")

说明:wp为我定义的类
查询表:courseevaluation
表项:classid       username     section
              11                   v1111       1-2
            (数值型)   (字符型)   (字符型)

郁闷!看不出错在那?大家帮忙看看,谢谢了.

------解决方案--------------------
wp.execute( "select name from courseevaluation where classid= " & ClassID & " and username= ' " & EvaluationUserNum & " ' and section= ' "& EvaluationSection & " ' ")
------解决方案--------------------
提示什么错误呀？

------解决方案--------------------
wp.execute( "select name from courseevaluation where classid= " & ClassID & " and username= ' " & EvaluationUserNum & " ' and section= ' "& EvaluationSection & " ' ")
这个