Recordcount problem with an oracle database

[Guest_imported]

Hello everybody!

I've got a problem.
I'm developping an ASP application.
I need to do a recordcount like this:

Dim arsTempo
Set arsTempo=Server.CreateObject("ADODB.Recordset&quot

SQLQuery = "SELECT A.ID, A.designation FROM RAPPORT R
INNER JOIN ACTIVITE A ON A.ID= R.refActivite GROUP BY
A.ID, A.Designation ORDER BY A.Designation, A.ID"
arsTemppen SQLQuery, acnCurrent, 3

if not arsTempo.EOF then
nbActivite = arsTempo.RecordCount
Response.Write("nb activité :" & nbActivite)
end if

it returned : "nb activité :-1"

I tried with doing arsTempo.movelast before the recordcount

Is there someone who knows what to do?

Thanks

 

[Palooka]

By default, you are not allowed to use rs.RecordCount. You have to set certain properties:

 rs.CursorLocation = adUseClient
 rs.CursorType = adOpenDynamic

Palooka

 

[dds82]

Even then, the documentation says that RecordCount may not return the correct value unless you've already moved to the end of the recordset. You need to do an rs.MoveLast before the rs.RecordCount.

I find the most reliable way to count records is to do it manually, in a loop...