这句怎么写?获不到值
<%
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