SitePoint Sponsor

User Tag List

Page 2 of 2 FirstFirst 12
Results 26 to 29 of 29
  1. #26
    SitePoint Guru
    Join Date
    Jun 2007
    Posts
    690
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Code ASP:
     
    Response.Redirect("mast.asp")
    Conn.close

    you should close the connections before redirecting...

  2. #27
    SitePoint Enthusiast lucky20's Avatar
    Join Date
    Oct 2010
    Posts
    97
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up

    @ webber ..yes you are right..

    I am copying my code and pasting here.. It was my mistake..

    corrected code:

    Conn.close
    Response.Redirect("Mast.asp")

  3. #28
    SitePoint Zealot
    Join Date
    Jan 2007
    Location
    Almere, The Netherlands
    Posts
    160
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Although I adviced you to use ASP.NET, which you obviously can't use, I also gave you a link how to use parameterized queries in classic asp. That's good coding practice. So I'm willing to help you also. you just don't see it....

  4. #29
    SitePoint Wizard bronze trophy
    Join Date
    Oct 2001
    Location
    Vancouver BC Canada
    Posts
    2,033
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)
    I appreciate glib suggestions about how technology B is better than technology A about as much as the next guy but to be fair verschha did make a relevant point about how you can improve the safety of an ASP script by passing SQL variables as parameters.

    Once you've got creating and destroying your connection and record set objects down pat and you're SQL statement are squeaky clean, you'll want to look into making things as secure as possible. This link is good. You'll probably find others by searching "vbscript sql parameter" or something similar. It's good to know about even if you don't use it.

    Good luck!
    Andrew Wasson | www.lunadesign.org
    Principal / Internet Development


Bookmarks

Posting Permissions

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