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