为什么我这样的查询没有数据显示呢？

[ljgfeixue]

<%
if request.Form("username")="" then
response.Write("请选择员工姓名")
elseif request("searchnian")="" then
response.Write("请输入要查询的年份")
elseif request("searchyue")="" then
response.Write("请输入要查询的月份")
else
username=trim(request("username"))
nian=trim(request("searchnian"))
yue=trim(request("searchyue"))
sql="select username,jblb,jbgz,jbts,qqlb,qqgz,qqts,ylfy,bxfy from [yggz] where username= &username& and nian= &nian& and yue= &yue& "
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,3
%>

[life360]

username= '"&username&"' and nian= '"&nian&"' and yue= '"&yue&"'

[ronakitty]

＂end if＂呢？

[ljgfeixue]

多谢，我试过了，还是不行啊

[cleaner77]

有nian和yue的字段吗?
sql="select username,jblb,jbgz,jbts,qqlb,qqgz,qqts,ylfy,bxfy from [yggz]
where username= '"&username&"' and nian='" &nian& "'and yue= '"&yue&"'"

[ronakitty]

username= '%"&username&"%'

[lovebeyondforever]

用查询分析器运行看看

[xingljx]

用下面语句试试看：
rs.open"select username,jblb,jbgz,jbts,qqlb,qqgz,qqts,ylfy,bxfy from [yggz]
where username= '"&username&"' and nian='" &nian& "'and yue= '"&yue&"'",conn,1

[ljgfeixue]

select username,jblb,jbgz,jbts,qqlb,qqgz,qqts,ylfy,bxfy from [yggz] where username= '晓峰' and nian= 2003 and yue= 5
这样可以在查询分析器里通过

[ronakitty]

更正：
username like '%"&username&"%'