rs help cont...

Results 1 to 3 of 3

Thread: rs help cont...

  1. #1
    Join Date
    Dec 1969

    Default rs help cont...

    Can anyone please tell me is rsTemp and rstemp the same thing?<BR><BR>Also can I have like a generic function with a close in it for rstemp, rstemp2, rstemp3 etc... and call it from a page even if there is only a rstemp but not a rstemp2 or rstemp3 loaded in that page?

  2. #2
    Join Date
    Dec 1969

    Default Ummm, what?

    For each recordset you define, you have to have an open and a close...<BR><BR>I usually do my structure indentation like this...<BR><BR> sql, conn<BR> while not rs.eof<BR> &#039;blah blah<BR> rs.movenext<BR> wend<BR>rs.close<BR><BR>Also, in VB, case does not matter, rstemp and RStemp are the same variable...<BR><BR>-- Whol

  3. #3
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Why not just

    pass the recordset to the function<BR><BR>Function CloseMe(RecordsetName)<BR>if RecordsetName is not nothing<BR>RecordsetName.close<BR>end if<BR>end function<BR><BR><BR>well something like this at least<BR><BR>

Posting Permissions

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