counting records in a recordset -- problem 1

[Stoemp]

I want to count the number of records in a recordset, but it always gives '-1' as a result.

Here's my code:

SET RS_products = Server.CreateObject("ADODB.RecordSet&quot
sSQL = "SELECT Id, naam, korte_beschr_" & sLang & " FROM producten WHERE subject_Id = " & sId
SET RS_products = conn.Execute(sSQL)

Response.Write(RS_producten.RecordCount)

What's wrong with this? I don't have a clue...

Thank you,
Steven

 

[GaryC123]

Probably to do with your cursor type, use AdOpenStatic with your connection Saturday 12.00

20.00

3.00am

Sunday [img http

 

[Stoemp]

Indeed, it was the cursortype I forgot. Now it works.

Thanks!!!

Steven