读书人

比较着急使用select count(*) 怎么得

发布时间: 2012-03-05 11:54:02 作者: rapoo

在线等,比较着急:使用select count(*) 如何得到结果??附带程序源码
markcount=request.form( "mark ")

set rsmark = server.CreateObject( "adodb.recordset ")
rsmark.open "select count(*) as tj from product where mark= ' "&markcount& " ' ",conn,1,1

if rsmark.eof and rsmark.bof then
response.write " <script language=javascript> alert( 'kong! ');history.go(-1); </script> "
rsmark.close

else
rsmark.movenext
test1=rsmark( "tj ")
dim sa
sa=222222222
response sa
mark=markcount+rsmark( "tj ")

sa=4444444444
response.write sa
end if
rsmark.close
set rsmark=nothing

[解决办法]
不明白你要干什么
[解决办法]
这样试试:

markcount=request.form( "mark ")

set rsmark = server.CreateObject( "adodb.recordset ")
rsmark.open "select count(*) as tj from product where mark= ' "&markcount& " ' ",conn,1,1
if rsmark.eof and rsmark.bof then
response.write " <script language=javascript> alert( 'kong! ');history.go(-1); </script> "
else
'rsmark.movenext
test1=rsmark( "tj ")
dim sa
sa=222222222
response sa
mark=markcount+rsmark( "tj ")
sa=4444444444
response.write sa
end if
rsmark.close
set rsmark=nothing
[解决办法]
rsmark.open "select A=count(*) from product where mark= ' "&markcount& " ' ",conn,1,1

[解决办法]
你要什么结果??是个数统计,还是加法统计?
如果你要rsmark的个数和,markcount=request.form( "mark ")

set rsmark = server.CreateObject( "adodb.recordset ")
rsmark.open "select count(rsmark) //把这个*号换成你要统计的属性列的名字
as tj from product where mark= ' "&markcount& " ' ",conn,1,1

if rsmark.eof and rsmark.bof then
response.write " <script language=javascript> alert( 'kong! ');history.go(-1); </script> "
rsmark.close

else
rsmark.movenext
test1=rsmark( "tj ")
dim sa
sa=222222222
response sa
mark=markcount+rsmark( "tj ")

sa=4444444444
response.write sa
end if
rsmark.close
set rsmark=nothing
[解决办法]
你应该要加一个group by

读书人网 >ASP

热点推荐