简单代码错在哪？？？急死了~

Question

Where workflow_id='"&session("RiseOffice_WorkflowID")&"' and  control_alias='"&字段_号&"'"

Answer 1

<%
    
Set RootRS=Server.CreateObject("ADODB.RecordSet")
Sql="SELECT control_value From workflowsnapshot Where workflow_id = "& "'" + Session("RiseOffice_WorkflowID")  & "'" &"and  control_alias="&"'"&"字段_号"&"'"    

RootRS.open Sql,Application("RiseOffice_ConnectionString"),1,3
     do while not rootrs.eof
controlvalue=rootrs("control_value")&","
%>
<%=controvalue%>
<%
rootrs.movenext
loop     
rootrs.close
%>