if i have a recordset "s" and I want to iterate through the cols in the rows. My problem is that I dont know how many cols. it has. How do I go about.

do while (not s.eof)
???????????????
s.movenext
loop

snip.... here

<%
Dim StrStudentID
Dim sRst
Dim fCount

StrStudentID = Request.QueryString("sid")
Set sRst = Conn.Execute("Select * from NewRegistration where studentid = " & CLng(StrStudentId))
fCount = sRst.Fields.Count
For q = 1 to CInt(fCount)-1
%>
<TR><TD><%=sRst.fields(q).Name%></TD><TD><%=sRst.fields(q)%></TD></TR>
<%
Next
%>

Is that you were asking?

With Regards,
Raghavendra Mudugal

Thanks buddy..
I saw in one of the sites.

MyArray=i.GetRows()
For lnRowCounter = 0 To Ubound(MyArray,2)
 For lnColumnCounter = 0 To Ubound(MyArray,1)
  Response.Write MyArray(lnColumnCounter, lnRowCounter)
Next
Next

*************
but urs is simpler.
Thanks again

The code runs fine but there is a small change-

for q = 0 to CInt(fCount)-1