How to return a recordset to an asp variable from a VB component?

Results 1 to 2 of 2

Thread: How to return a recordset to an asp variable from a VB component?

  1. #1
    Join Date
    Dec 1969
    Posts
    170

    Default How to return a recordset to an asp variable from a VB component?

    Could someone please help me with a code sample that shows how to return a recordset to an asp variable from a VB component? I&#039ve found the code for getting a recordset directly, but I want to hide my access code by using a dll on the server. <BR><BR>I&#039m stumped here.<BR><BR>Thanks, Julie

  2. #2
    Join Date
    Dec 1969
    Posts
    8

    Default RE: How to return a recordset to an asp variable from a VB component?

    VB:<BR>Function GetRecordset() as Variant<BR> Dim rst as ADODB.Recordset <BR> &#039open recordset<BR> &#039....<BR> &#039....<BR> Set GetRecordset = rst<BR>End Function<BR><BR>ASP:<BR>Dim obj<BR>Dim rst<BR><BR>Set obj = Server.CreateObject("MyDll.MyClass")<BR>Set rst = obj.GetRecordset<BR>Set obj = Nothing

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •