这句怎么写？获不到值
<%  
        dim   total
        sql= "select   count(id)   from   changejob   where   name= "&rs( "worker ")& " "
set   total=conn.execute(sql)
total=total(0)
response.write "total= "&total& "worker= "&trim(rs( "worker "))& " "
%>
其中where   name= "&rs( "worker ")& " "   这句获不到值
怎么处理

------解决方案--------------------
sql= "select count(id) from changejob where name= ' " & rs( "worker ") & " ' "
set total=conn.execute(sql)
totalnum = total(0)
total.close
set total = nothing
conn.close
set conn = nothing