Passing variables to Subroutines

Results 1 to 2 of 2

Thread: Passing variables to Subroutines

  1. #1
    Conn Guest

    Default Passing variables to Subroutines

    Hi,<BR> can anyone show me how to pass Recordset or an Array to a subroutine?

  2. #2
    Ed Guest

    Default RE: Passing variables to Subroutines

    Sub ListRecordSet(objRecordSet)<BR><BR>Do While Not objRecordSet.EOF<BR>&#039Do something<BR>objRecordSet.MoveNext<BR>Loop<BR><BR> End Sub<BR><BR>Dim objRS<BR>Set objRS = Server.CreateObject("ADODB.Recordset")<BR>objRS.Op en "SELECT * FROM TableName", objConn<BR><BR>ListRecordSet(objRS)

Posting Permissions

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