Using EOF loop twice?

Results 1 to 2 of 2

Thread: Using EOF loop twice?

  1. #1
    Join Date
    Dec 1969

    Default Using EOF loop twice?

    Hi, it&#039;s the rookie again...<BR><BR>How can I use loops twice?<BR>I need to print this on the page and I also<BR>would like to send the same information by email.<BR>(So I need to get it to the email body as well)<BR><BR>&#060;%<BR>Do While NOT Rs1.EOF<BR>Response.Write(Rs1.Fields("blaablaa1"). value)<BR>Response.Write(Rs1.Fields("blaablaa2").v alue)<BR>Rs1.MoveNext<BR>Loop<BR>%&#062;

  2. #2
    Join Date
    Dec 1969

    Default Lookup these

    .moveFirst<BR><BR>And, for better performance gains:<BR>rs.GetRows<BR><BR>Oh, and just because you need to do it twice doesn&#039;t mean that you *have* to do it separately elsewhere on the page. You could put a table/display into a string variable while you looped for the email, for instance.

Posting Permissions

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