contare records

[Okocha]

Ciao,
vorrei contare i record di una tabella.
Lo script è questo:

<%
'Open connection to database
set con = server.createObject("ADODB.Connection")
con.open(strServerConnection)

sqlString = "Select Email from Newsletter Where Status = 0 ORDER BY Email"
set rs = con.execute(sqlString)

'Loop and print table
while not rs.eof
	userString = replace(rs("Email"), " ", "+")
	output = output & "<tr bg color=#EEEEEE><td width=""75%"" bgcolor=#EEEEEE>"&rs("Email")&"<td width=""25%"" bgcolor=#EEEEEE><div align=center><a href=listSubscribers.asp?function=delete&email="&userString&"&redirect=inactive.asp>Delete</a></div></td></tr>"
	rs.moveNext
wend

response.write(output)
%>

ho visto che dovrei usare il select count(*), ma non so come inserirlo.

qualcuno sa aiutarmi?

[optime]

devi fare due interrogazioni, una per il COUNT e l'altra per come la usi adesso

per il count usa

SELECT COUNT(campo) FROM tabella WHERE ....

e poi leggi RS(0)

[Okocha]

....
con.open(strServerConnection)

sqlString = "Select Email from Newsletter Where Status = 0 ORDER BY Email"
sqlCount = "Select Count(Email) from Newsletter Where Status = 0"

set rs = con.execute(sqlString)

'Loop and print table
....

l'ho inserito in quel punto

ma mi da questo errore
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
linea 0

alla linea 0

[optime]

DUE query vuol dire

sql=....count....
set rs=con.execute(sql)
nRecs=rs(0)
set rs=nothing

sql=quello che fai adesso
set rs=con.execute(sql)
.....

[Okocha]

<%
'Open connection to database
set con = server.createObject("ADODB.Connection")
con.open(strServerConnection)

sqlString = "Select Email from Newsletter Where Status = 0 ORDER BY Email"
sqlCount = "Select Count(Email) from Newsletter Where Status = 0"

set rs = con.execute(sqlString)

'Loop and print table
while not rs.eof
	userString = replace(rs("Email"), " ", "+")
	output = output & "<tr bg color=#EEEEEE><td width=""75%"" bgcolor=#EEEEEE>"&rs("Email")&"<td width=""25%"" bgcolor=#EEEEEE><div align=center><a href=listSubscribers.asp?function=delete&email="&userString&"&redirect=inactive.asp>Delete</a></div></td></tr>"
	rs.moveNext
wend

response.write(output)

set rs = con.execute(sqlCount)
%>

ho fatto così e funziona.

Grazie mille!

[optime]

optime!