My recordSet reads only three rows!
I have a problem with my script:
set recordSet = Server.CreateObject("ADODB.Recordset")
recordSet.MaxRecords = 100
set connection = Server.CreateObject("ADODB.Connection")
sqlQuery = "SELECT * FROM contacts_tbl"
connectionString = "Provider=sqloledb; Server=JOHNY-PC; Database=organiser; Trusted_Connection=Yes;"
recordSet.Open sqlQuery, connection
Response.Write("<br>records: " & recordset.Fields.Count)
So - in the last line I'm checking quantity of returned rows. Whatever is my sqlQuery string, recordSet always reads three rows. Why it is like that? How can I fix it?