I have created a stored procedure to search data. It is pretty simple one too. I wanted to get a recordset by executing the stored procedure and show 100 records for page. But It is showint the provider not able to support the operation when i try setting absolute page value, Also I am getting recordcount as -1.
The stoered proc is
CREATE PROCEDURE GetStocklist
declare @cmd varchar(500);
set @cmd = ''
set @cmd = "select part_no,dc,mf,qty,price,dateofferred from Availables where part_no"
if @searchtype = "full"
set @cmd = @cmd + "= " + @partno;
set @cmd = @cmd + " like '%" + @partno + "%'";
the Active server Page page uses
rs.cursortype = 1 'adopenstatic (I tried 3 also)
rs.locktype = 4 'adlockReadonly (I tried 1 also)
rs.pageSize = 100
set rs = cmd.execute
rs.AbsolutePage = pageno (here I am getting error)
however when i print the cursortype and locktype after the cmd.execute statement, I am getting values 0 and 1 respectively.
Can you throw some light on it.