Record Count ?

[lardy]

Hi,
i couldnt count the number of records, i have this table:

table:

id | acct
1 Administrator
2 Accounting
3 Administrator

<Code:>
<!-- #include file="p_conn.asp" -->
<%
dim rsadmin,sqladmin,u,x


u="Administrator"

set rsadmin=server.createobject("adodb.recordset")
sqladmin="select * from users where acct='"&Administrator&"'"

rsadmin.open sqladmin,conn,1,3

do while not rsadmin.eof
x=1

x=x+1

rsadmin.movenext
loop


%>
Total Admin=<%=x%>

</Code:>

it only writes Total Admin! the x value is missing -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[jami]

You can just use:

Code:

set rsadmin=server.createobject("adodb.recordset")
sqladmin="select * from users where acct='"&Administrator&"'"
rsadmin.open sqladmin,conn,1,1

response.write rsadmin.recordcount

It works very well as i always use it. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --