asp中“文字”变量的查询

    dim ss
   ss="绩效任务"
 
set rs=server.createobject("adodb.recordset")
sql="select * from workrep where username=" & sqlstr(name) &"and jclass='"&ss&"'"
rs.open sql,conn,1

转载于:https://www.cnblogs.com/yeye518/archive/2008/02/29/2231801.html