注册 登录
编程论坛 SQL Server论坛

为什么我的会员统计会有语法错误

adweset 发布于 2009-07-21 21:53, 801 次点击
表user   自动编号id  我想统计出有多少会员可是有语法错误??????????????
sql="select count(*) As id from user"
'set rs = conn.execute(sql)
rs.Open (sql),conn,1,1
Totaluser = rs("id")
rs.close


我统计歌曲都可以
sql="select count(*) As ID from MusicList"
'set rs = conn.execute(sql)
rs.Open (sql),conn,1,1
TotalMusicList = rs("ID")
rs.close   这个可以统计出而上面的不行



还请大虾们指教!!!!!!!!!!!


只有本站会员才能查看附件,请 登录
3 回复
#2
wzg03192009-07-22 13:48
你这句是什意思。。rs.Open (sql),conn,1,1死我活 ?
要不你把完整的代码发出来看一下
#3
zhong07111012009-07-27 17:09
把完整的代码发出来看一下
#4
adweset2009-07-30 20:23
<%
SET rs = Server.CreateObject("ADODB.Recordset")
sql="select count(*) As NClassID from NClass"
'set rs = conn.execute(sql)
rs.Open (sql),conn,1,1
TotalNClass = rs("NClassid")
rs.close
sql="select count(*) As SpecialID from Special"
'set rs = conn.execute(sql)
rs.Open (sql),conn,1,1
TotalSpecial = rs("Specialid")
rs.close
sql="select count(*) As MusiclistID from Musiclist"
'set rs = conn.execute(sql)
rs.Open (sql),conn,1,1
TotalMusiclist = rs("Musiclistid")
rs.close
sql="select count(*) As ID from myuser"
'set rs = conn.execute(sql)
rs.Open (sql),conn,1,1
Totalmyuser = rs("id")
rs.close
rs.Open ("select sum(hits) from Musiclist"),conn,1,1
all_count=rs(0)
rs.Close
conn.Close
set rs=nothing
set conn=nothing
n=Year(date())
y=Month(date())
r=Day(date())
%>
共有歌手:<b><%=TotalNClass%></b>位&nbsp&nbsp
共有专辑:<b><%=TotalSpecial%></b>张&nbsp&nbsp
共有歌曲:<b><%=TotalMusiclist%></b>首&nbsp&nbsp
共有会员:<b><%=Totalmyuser%></b>位&nbsp&nbsp
累计点播数:<font color='#FF00FF'><%=all_count%></font>次&nbsp&nbsp
1