Response.Redirect and Connections

Results 1 to 3 of 3

Thread: Response.Redirect and Connections

  1. #1
    SteveW Guest

    Default Response.Redirect and Connections

    I open connections to the database and then Response.Redirect if a condition is met.<BR><BR>If I do that I guess the connection and recordset objects aren&#039t being destroyed on that page... Does this matter, and if they are not explicitly destroyed how long do they persist?<BR>

  2. #2
    Join Date
    Dec 1969

    Default very simple..

    before redirection close connection and release it .<BR>for example<BR>&#039open conn<BR>if weather = "hot" then<BR>//do something<BR>else &#039redirect<BR> &#039close and release before redirection<BR> conn.close<BR> set conn = nothing<BR> <BR> &#039redirect<BR> response.redirect "file1.asp"<BR>end if <BR>end if<BR>

  3. #3
    Steve W Guest

    Default Doh... Thanks!

    Doh... Thanks!

Posting Permissions

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