请问asp的command支持.ExecuteScalar()吗？

[wlboy110]

想在一个查询记录字段显示表格里面再做一个查询
<%
Comm.CommandText="SELECT ( SELECT count(*)+1 as dd FROM PM_YGKHB as a where a.ZHPZDF > b.ZHPZDF ) AS bb, b.ZHPZDF, YGXM FROM PM_YGKHB AS b where YGXM='"&rs("XM")&"' order by b.ZHPZDF desc "
Response.write Comm.ExecuteScalar
%>
这样的想法在asp里面应该怎么实现呢？

[online]

这是.net的用法

这样
conn.execute("SELECT ( SELECT count(*)+1 as dd FROM PM_YGKHB as a where a.ZHPZDF > b.ZHPZDF ) AS bb, b.ZHPZDF, YGXM FROM PM_YGKHB AS b where YGXM='"&rs("XM")&"' order by b.ZHPZDF desc ")