> > boost. Having a minor issue I haven't looked into now with not being
> > able to get the SP results through ADO, but I'm sure I'll be able to
> > figure that one out...
> Just select at the end of the SP the data you want in the Recordset:
> Now when you call that sp with ado the recordset will get all the data
> the last command is selecting:
>
> (Untested code)
>
> dim oconn as adodb.connection
> dim ors as adodb.recordset
>
> set oconn = new adodb.connection
>
> let oconn.connectionstring = "your connection string"
>
> oconn.open
>
> 'now call the sp and get the data into the recordset:
> set ors = oconn.execute("test_sp")
>
> do while not ors.eof
> debug.print ors.fields(0).value
> ors.movenext
> loop
Yes, this is roughly the code I have, but the resultset is empty for
some reason. I'll be digging into it today. Thanks.
--
Derek
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
