SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Oct 2010
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Optimize a old ASP application

    I am basically a .Net programmer and I know very little about old ASP. Now, we do not have time to convert it to .Net. The application is pretty big and has lots of embedded SQL inside the code. We fear SQL injections. What are the options I have now?

    1. Accumulate all those SQLs in a COM DLL(?)
    2. Is it possible to parametrize queries?
    3. Any other solution?

    Sample code will be appreciated. Thanks in advance.

  2. #2
    SitePoint Guru
    Join Date
    Jun 2007
    Posts
    686
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Preventing SQL injection

    Sample code is under the C# tab, although it looks like vbScript to me

  3. #3
    SitePoint Zealot
    Join Date
    Jan 2007
    Location
    Almere, The Netherlands
    Posts
    160
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by sagittarian View Post
    2. Is it possible to parametrize queries?
    Yes

    http://blog.binarybooyah.com/blog/po...rized-SQL.aspx


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
  •