sp_helplogins, nextrecordset

[Sharon]

Hi,

I am executing the sp_helplogins on my database, in an
effort to obtain all the databases and roles a user has,
for usage in an ASP menu of sorts.

sp_helplogins returns 2 recordsets, the first of which I
could care less about. The second contains all the
records I want to parse through.

It never moves to the next record though. It only prints
out (and continuously prints out) the first record.

What's wrong here?
Thanks!


<snippet>

cSql = "EXEC sp_helplogins '" & cOffID & "'"
set oRs=oConn.execute(cSql)

oRs = oRs.NextRecordset
Do While Not oRs.EOF
Response.Write oRs("DBName")
Response.Write oRs("UserName")
' this prints out the first record, over and over...
oRs.MoveNext
Loop

<end snippet>

[Bob Barrows [MVP]]

See inline:
Sharon wrote:

> Hi,
>
> I am executing the sp_helplogins on my database, in an
> effort to obtain all the databases and roles a user has,
> for usage in an ASP menu of sorts.
>
> sp_helplogins returns 2 recordsets, the first of which I
> could care less about. The second contains all the
> records I want to parse through.
>
> It never moves to the next record though. It only prints
> out (and continuously prints out) the first record.
>
> What's wrong here?
> Thanks!
>
>
> <snippet>
>
> cSql = "EXEC sp_helplogins '" & cOffID & "'"
> set oRs=oConn.execute(cSql)
>
> oRs = oRs.NextRecordset

this should be
Set oRS = oRs.NextRecordset

> Do While Not oRs.EOF
> Response.Write oRs("DBName")
> Response.Write oRs("UserName")
> ' this prints out the first record, over and over...
> oRs.MoveNext
> Loop
>
> <end snippet>

See if the above change fixes it. If not, I'll try to reproduce the problem.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Sharon]

That worked!!! THANK YOU.
Sharon

>-----Original Message-----
>See inline:
>this should be
>Set oRS = oRs.NextRecordset
>
>See if the above change fixes it. If not, I'll try to

reproduce the problem.

>
>Bob Barrows
>
>--
>Microsoft MVP -- ASP/ASP.NET
>Please reply to the newsgroup. The email account listed

in my From

>header is my spam trap, so I don't check it very often.

You will get a

>quicker response by posting to the newsgroup.
>
>
>.
>