paging recordset

• • Reply

  17 years ago

  by bogdan

  Bogdan Iliescu

  FL, USA, United States

  Joined 19 years ago

  Hi,
  I have the following problem: I want to set AbsolutPage, PageSize properties for a recordset; this recordset is filled up with data which result from execution of a stored procedure, but I receive an error msg - provider does not support this opperation or something like this
  

  
  I use an ODBC connection (system dsn).
  

  
  Here is my code:
  

  Code:

  
  

  
  Set cmdRaspuns = Server.CreateObject("ADODB.Command")
  Set rs = Server.CreateObject("ADODB.Recordset")
  

  
  Set cmdRaspuns.ActiveConnection = cn
  With cmdRaspuns
     .CommandText="sp_getintrebariraspuns"
     .CommandType=adCmdStoredProc
  End With
  

  
  Set pId = cmdRaspuns.CreateParameter("@mid", adInteger, adParamInput, 4)
  pId.Value = wId
  cmdRaspuns.Parameters.Append pId
  

  
  rs.CursorLocation = 2
  rs.CursorType = 3
  rs.PageSize=10
  

  
  Set rs = cmdRaspuns.Execute
  

  
  rs.AbsolutePage=CINT(wNumarPagina)
  

  Code:

  
  

  
  Any help will by appreciated!
  Thanks

  Report abuse