<%
Function getNumByDWID(id,opt)
'Set mRs = Server.CreateObject("ADODB.Recordset")
Text="select count(options) as num from inform where options like '%" +cstr(id)+","+opt+ "%'" set mRs=myConn.execute(text)
j=mRs("num")
getNumByDWID=j
mRs.close
set mRs=nothingEnd Function Set Rs = Server.CreateObject("ADODB.Recordset")
Textsql="select * from danwei"
Rs.Open Textsql,myConn,1,1
i=0
Temp = ""
Temp = Temp + "<table cellSpacing='1' cellPadding='0' style='' class='table' align='center'>"
Temp = Temp + "<tr class='trTitle'>"
Temp = Temp + "<td class='tdTitle' colspan='5' align='center'>***民主评议</td>"
Temp = Temp + "</tr>"
Temp = Temp + "<tr class='trTitle'>"
Temp = Temp + "<td class='tdTitle'>序号</td>"
Temp = Temp + "<td class='tdTitle'>单位</td>"
Temp = Temp + "<td class='tdTitle'>满意</td>"
Temp = Temp + "<td class='tdTitle'>基本满意</td>"
Temp = Temp + "<td class='tdTitle'>不满意</td>"
Temp = Temp + "</tr>" while not rs.eof
i=i+1
Temp = Temp + "<tr class='tr'>"
Temp = Temp + "<td class='td'>"+cstr(i)+"</td>"
Temp = Temp + "<td class='td'>"+rs("danwei")+"</td>"
Temp = Temp + "<td class='td'>"+cstr(getNumByDWID(rs("id"),"a"))+"</td>"
Temp = Temp + "<td class='td'>"+cstr(getNumByDWID(rs("id"),"b"))+"</td>"
Temp = Temp + "<td class='td'>"+cstr(getNumByDWID(rs("id"),"c"))+"</td>"
Temp = Temp + "</tr>"
'添加新数据到piaoshu表中
set Rs2=server.CreateObject("adodb.recordset")
sql="select * from piaoshu"
Rs2.open sql,myConn,1,3
Rs2.addnew
Rs2("id")=cint(cstr(i))
Rs2("danwei")=rs("danwei")
Rs2("piaoshu")=cint(cstr(getNumByDWID(cstr(rs("id")),"a")))
Rs2("aaa")=cint(cstr(getNumByDWID(cstr(rs("id")),"a")))
Rs2("bbb")=cint(cstr(getNumByDWID(cstr(rs("id")),"b")))
Rs2("ccc")=cint(cstr(getNumByDWID(cstr(rs("id")),"c")))
Rs2.update
Rs2.close
set Rs2=nothing
rs.movenext
wend
rs.close
set rs=nothing
myConn.close
set myConn=nothing
Temp = Temp + "</table>"
response.write Temp
response.Write("报告,新数据已经更新到piaoshu表中,你可以通过Tablepiaoshu表来查询票数最高的单位")
%>
各位同志好,大家帮忙看下上面的程序,我这个程序想实现的功能是统计各个单位的票数,存储的方式是单位序号+“,”+满意度(满意用A,一般用B,不满意用C),132个单位都存在options字段里,(1,a|2,a|3,c|4,a),可现在的问题是,在模糊查询时,统计序号为4的单位时,他会把14,24,34,54都统计上,请问这个怎么改呀,谢谢
Function getNumByDWID(id,opt)
'Set mRs = Server.CreateObject("ADODB.Recordset")
Text="select count(options) as num from inform where options like '%" +cstr(id)+","+opt+ "%'" set mRs=myConn.execute(text)
j=mRs("num")
getNumByDWID=j
mRs.close
set mRs=nothingEnd Function Set Rs = Server.CreateObject("ADODB.Recordset")
Textsql="select * from danwei"
Rs.Open Textsql,myConn,1,1
i=0
Temp = ""
Temp = Temp + "<table cellSpacing='1' cellPadding='0' style='' class='table' align='center'>"
Temp = Temp + "<tr class='trTitle'>"
Temp = Temp + "<td class='tdTitle' colspan='5' align='center'>***民主评议</td>"
Temp = Temp + "</tr>"
Temp = Temp + "<tr class='trTitle'>"
Temp = Temp + "<td class='tdTitle'>序号</td>"
Temp = Temp + "<td class='tdTitle'>单位</td>"
Temp = Temp + "<td class='tdTitle'>满意</td>"
Temp = Temp + "<td class='tdTitle'>基本满意</td>"
Temp = Temp + "<td class='tdTitle'>不满意</td>"
Temp = Temp + "</tr>" while not rs.eof
i=i+1
Temp = Temp + "<tr class='tr'>"
Temp = Temp + "<td class='td'>"+cstr(i)+"</td>"
Temp = Temp + "<td class='td'>"+rs("danwei")+"</td>"
Temp = Temp + "<td class='td'>"+cstr(getNumByDWID(rs("id"),"a"))+"</td>"
Temp = Temp + "<td class='td'>"+cstr(getNumByDWID(rs("id"),"b"))+"</td>"
Temp = Temp + "<td class='td'>"+cstr(getNumByDWID(rs("id"),"c"))+"</td>"
Temp = Temp + "</tr>"
'添加新数据到piaoshu表中
set Rs2=server.CreateObject("adodb.recordset")
sql="select * from piaoshu"
Rs2.open sql,myConn,1,3
Rs2.addnew
Rs2("id")=cint(cstr(i))
Rs2("danwei")=rs("danwei")
Rs2("piaoshu")=cint(cstr(getNumByDWID(cstr(rs("id")),"a")))
Rs2("aaa")=cint(cstr(getNumByDWID(cstr(rs("id")),"a")))
Rs2("bbb")=cint(cstr(getNumByDWID(cstr(rs("id")),"b")))
Rs2("ccc")=cint(cstr(getNumByDWID(cstr(rs("id")),"c")))
Rs2.update
Rs2.close
set Rs2=nothing
rs.movenext
wend
rs.close
set rs=nothing
myConn.close
set myConn=nothing
Temp = Temp + "</table>"
response.write Temp
response.Write("报告,新数据已经更新到piaoshu表中,你可以通过Tablepiaoshu表来查询票数最高的单位")
%>
各位同志好,大家帮忙看下上面的程序,我这个程序想实现的功能是统计各个单位的票数,存储的方式是单位序号+“,”+满意度(满意用A,一般用B,不满意用C),132个单位都存在options字段里,(1,a|2,a|3,c|4,a),可现在的问题是,在模糊查询时,统计序号为4的单位时,他会把14,24,34,54都统计上,请问这个怎么改呀,谢谢
解决方案 »
- WINFORM中的COMBOBOX
- 关于Spring.Net的问题
- 网站上允许 .csv 文件可以下载,在iis哪里设置?
- 求高手帮忙:我在执行asp.net时它提示说:"服务器无法访问应用程序目录,该目录不存在或因为安全设置而无法访问。"
- WebClient OpenWrite上传文件 .NET2.0通过, 1.1 用提示未知用户与密码
- 一个小问题的讨论,我用 dataReader 把数据记录 从 数据库提取出来后 , 要显示到客户端 ,这个时候我是用 DataList ,repeater .服务器端绑定,还是采用 数据记录+ html 混合在一起 ,而后赋给一个Div的innerHtm
- Asp.Net 如何抓图
- 各位高手进啊...............
- 带参数输出的存储过程。居然运行的结果是Output ,因该是值啊!
- 新人求指教!!!!!!!!!!
- 请问主从关系在实体中应该如何设计呢 ?
- 如何在自己的会员系统中使用profile
*****************************************************************************
欢迎使用CSDN论坛专用阅读器 : CSDN Reader(附全部源代码) http://feiyun0112.cnblogs.com/
你的意思输入4后出现的是那些?
是 4,41,42,43,……,
不要14,24,34
是吗?
没有意义。
不如直接一个一个查了,不用模糊查询 。
Text="select count(options) as num from inform where options =cstr(id)"
这样肯定取不到第一和最后一条记录
改进一下
Text="select count(options) as num from inform where ('¦'+options+'¦' like '%¦" +cstr(id)+","+opt+"¦%'") or (options+'¦' like '" +cstr(id)+","+opt+"¦%'") or ('¦'+options like '%¦" +cstr(id)+","+opt+"'")这样做真是给自己找麻烦~~
Text="select count(options) as num from inform where options="&cstr(id)&" and options like '%" +cstr(id)+","+opt+ "%'"
set mRs=myConn.execute(text)