Returning recordsets from functions

Results 1 to 5 of 5

Thread: Returning recordsets from functions

  1. #1
    Ollie Cornes Guest

    Default Returning recordsets from functions

    &nbsp;<BR>How do I return a recordset from a VBScript function? I imagine it is possible returning is directly, but also using a parameter passed by reference.

  2. #2
    Ollie Cornes Guest

    Default Still waiting for a reply :(

    .

  3. #3
    Join Date
    Dec 1969
    Posts
    11,334

    Default For TWO YEARS???

    Geez... thought you could get it by now!<BR><BR>

  4. #4
    Join Date
    Dec 1969
    Posts
    1,849

    Default What exactly are you trying to do?

    I don&#039;t believe you can. You can create a global conn object, and recordset, and set the values inside a sub, but I do not believe that you can pass a recordset between subs without a global recordset....<BR><BR>eg:<BR>&#060;%<BR>strConnect= "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("database.mdb") <BR> set ObjConn=Server.CreateObject("ADODB.Connection")<BR >sub test ()<BR> SQL = "select * from table"<BR> set objrec = objconn.execute(SQL)<BR>end sub<BR><BR>dim objrec<BR>objconn.open strconnect<BR>test<BR>response.write(objrec.fields (0).value)<BR>objconn.close<BR><BR><BR><BR>%&#062; <BR><BR>-- Whol


  5. #5
    Justin Bonaparte Guest

    Default LOL! He has a patient customer <eop>

    .

Posting Permissions

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