[thelist] returning the equiv. of rs.RecordCount with a stored procedure? (SQL7)

[Chris Blessing]

Doh!  Man I can't believe I missed that.  You'd think that since I was
already using that syntax but with a query instead of the sp name, I could
put 2+2 together to figure it out (or dig out some vague memories of the
open method <shudder>).

I think you and I are on the same "making things far too complex" plane of
this universe.  Thanks!

And thanks Matt, for your input as well.

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

> I forgot a third way, which is probably the easiest -- just open the
> recordset with the stored procedure name
>
> Set RS = Server.CreateObject("ADODB.Recordset")
> RS.Open "myProcedure", Conn, adOpenStatic, adLockReadOnly, adCmdStoredProc
>
> Duh. Always trying to be too fancy -- my downfall. (: