I'm trying to move my ASP VB Script recordset code from being a recordset into being an array...
my code currently looks like --
RSPartner__MMColParam = 0
If (Request("i") <> "") Then
RSPartner__MMColParam = Request("i")
Set RSPartner_cmd = Server.CreateObject ("ADODB.Command")
RSPartner_cmd.ActiveConnection = MM_Connection_STRING
RSPartner_cmd.CommandText = "SELECT ID, FirstName, LastName, ClubName FROM dbo.Member WHERE ID <> ?"
RSPartner_cmd.Prepared = true
RSPartner_cmd.Parameters.Append RSPartner_cmd.CreateParameter("param1", 5, 1, -1, RSPartner__MMColParam) ' adDouble
Set RSPartner = RSPartner_cmd.Execute
RSPartner_numRows = 0
Is there an easy way of doing this? Do I just need to add something to the bottom?
Also, how do I limit the number of results returned, and how do I page through the results.. like 1|2|3|4.. etc..
Currently with Recordsets accessi9ng the database, i have some script on my page that creates the recorset navigation links like those listed above..