Passing Recordset to a function

[vinod kadam]

Hello,

How to pass a ADODB recordset to a function written in VBScript in ASP+ & how to access that recorset object in the fuction?
Reply soon.
Vinod.

[Johnny101]

declare your sub like this:

Sub GetRecordset(rs)

End Sub




then when you need to use this recordset in the routine - just reference it like you would any other variable:

Sub GetRecordset(rs)
dim i

for i = 0 to rs.fields.count - 1
response.write rs(i).name & " - " & rs(i).value
next i

End Sub




call this routine like this:

...code to build your recordset (rsMain)

Call GetRecordset(rsMain)




that should do it.

hope this helps,

John

John Pirkey
MCSD
http://www.ShallowWaterSystems.com
http://www.stlvbug.org