我想查询一个表中某个字段的记录总数,我这样写代码:
<%
sqlcount="select count(*) from product where SmallClassName='"&rsSmallClass("SmallClassName")&"'"
response.Write(sqlcount)
%>
但是这样不能取出记录总数的值,请教各位大侠该怎么写才能取出记录总数的值呢,另外,我写的取记录总数的sql语句对不对?
------解决方案--------------------
- VBScript code
<% sql = "select count(*) from product where SmallClassName='" & rsSmallClass("SmallClassName") & "'" set rs = CreateObject("ADODB.RecordSet") rs.CursorLocation = 3 rs.Open sql, conn, 1, 1 response.Write rs(0) rs.Close %>
------解决方案--------------------