Respected Sir,
I have some problem regarding recordset. Sir I have wrote one stored procedure. I want to display the records from the stored procedure.
Sir, My details about the problem is listed below:Stored procedure name is demo and it has the following data in it:
Create procedure demo
as
(
select * from demo
)
-------------------table fiels are id,name
<%
dim rs
set rs=Server.createobject("Adodb.recordset")
rs.open "Exec demo",con,1,2
%>
<%=rs("id")%>
<%=rs("name")%>
But i am getting only one record i want to get 10 records as there are 10 records available in table demo.
Sir we can use the while loop or do while or for loop to get the remaining records but i don't want to use it i want to get the records without using any loops.
Sir, Please solve my problem as quickly as possible.
Thanking You,
Enter your message below
Sign in or Join us (it's free).