日期:2014-05-17  浏览次数:21091 次

在线等,比较着急:使用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