% ufeed = replace(replace(request("feed"),"'","''"),"""","""""") 'sdate = replace(replace(request.QueryString("sdate"),"'","''"),"""","""""") session("sdate")= replace(replace(request.QueryString("sdate"),"'","''"),"""","""""") if session("sdate")<>"" then session("sdate1")=session("sdate") 'response.Write(session("sdate1")) end if 'response.End() 'if request.ServerVariables("REQUEST_METHOD")="POST" then 'if request.ServerVariables("REQUEST_METHOD")="POST" then 'if request.ServerVariables("REQUEST_METHOD")="POST" then set rs = server.CreateObject("adodb.recordset") sqlstr="" if ufeed<>"" then sqlstr="select * from Results_tbl where hallticketno='"&ufeed&"' and date='"&session("sdate1")&"'" 'response.Write(sqlstr) 'response.End() end if if ufeed ="" then 'if request.ServerVariables("REQUEST_METHOD")="POST" then 'sqlstr="select * from feedback_tbl order by 1 asc" sqlstr="select * from Results_tbl where hallticketno='"&ufeed&"'" 'sqcount="select count(ID) as count, sum(cast(Percentage as int)) as spercentage from feedback_tbl group by ID" 'response.Write(sqlstr) 'response.End() end if set rs= Conn.execute(sqlstr) 'i=rs.RecordCount 'response.Write(i) 'end if 'end if %>