Guest_imported
New member
- Jan 1, 1970
- 0
- 0
- 0
Hello everybody!
I've got a new problem.
I'm developping an ASP application.
I need to do a recordcount like this:
Dim arsTempo
Set arsTempo=Server.CreateObject("ADODB.Recordset"
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
I've got a new problem.
I'm developping an ASP application.
I need to do a recordcount like this:
Dim arsTempo
Set arsTempo=Server.CreateObject("ADODB.Recordset"
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