找错误

[supchen]

set score=server.createobject("ADODB.Command")
score.activeconnection= "database1"
score.commandtext="select count(*) from bmb where schoolname='"&schoolname&"' and kaoshenglb='"&kaoshenglb&"' and kaoshilb='"&kaoshilb&"';"
set sc=score.execute
Nuscore=sc("count(*)")
在最后一句有什么错误?

[秋风ss落叶]

错！
score.commandtext="select count(*) AS xxx from bmb where schoolname='"&schoolname&"'

...

Nuscore=sc("xxx")

[cmsoft]

score.commandtext="select count(*) from bmb where schoolname='"&schoolname&"' and kaoshenglb='"&kaoshenglb&"' and kaoshilb='"&kaoshilb&"';"
这句最后的分号去掉啊

[sjhasp]

取出记录总数给Nuscore

[cmsoft]

Sql="select count(*) as num from bmb where schoolname='"&schoolname&"' and kaoshenglb='"&kaoshenglb&"' and kaoshilb='"&kaoshilb&"'"
set sc=score.execute(Sql)
Nuscore=sc("count(*)")

[cmsoft]

错了，最后一句改成:

Nuscore=sc("num")

[超级大笨狼]

Nuscore=sc("count(*)")
你混了sql语句和vbs代码，"count(*)"在这句话里是不会被当作sql运算的,一定要用中间变量as一下才能够达到你的目的。
还有and kaoshilb='"&kaoshilb&"';"多了一个分号

[tripofdream]

需要给计算字段一个别名(alias)来作为字段名引用.
SQL语句结加";"是正确的,可以用";"来一次执行多个SQL语句.