Return a Recordset from the called Function

[trezlub]

If I run some SQL to generate a recordset within a called function, how can I return the recordset back to the calling function/procedure?

Example:
--------------------------------------

<%
Dim recordset
GetRecordset recordset 'calling procedure

'would like to be able to manipulate &quot;recordset&quot; here
%>

<%
Private Function GetRecordset()

'Called Function
'...something to create a recordset

End Function
%>

 

[mumbojumbo]

<%
myRs = GetRecordset('youcould have prams here')
%>

<%
Private Function GetRecordset('youcould have prams here')
set rs = db.execute(&quot;select * from pt&quot
GetRecordset = rs
End Function
%>

 

[Bullschmidt]

The easy way would be for the recordset object to be created outside of the function but of course be used inside...

Best regards,
J. Paul Schmidt - Freelance ASP Web Developer

http://www.Bullschmidt.com

- Creating &quot;dynamic&quot; Web pages that read and write from databases...

 

[trezlub]

Cheers mumbojumbo and Bullschimdt, both ideas are very good and helpful. The problem I had has now been solved.

 

[mumbojumbo]

If its helpful.. hit a star.. it helps readers to find a solution

<sub><img src=

http://www.pleasuretoy.co.uk/temp/alf2.gif></sub>