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