Derek Kalweit wrote:
>
> 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:
create proc test_sp
as
select * from sysobjects
-------------
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
..............
HTH
Saludos
Jaime Vasquez
_______________________________________________
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.
