Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

SQL Injection Keywords

  • 22-06-2009 05:14PM
    #1
    Registered Users, Registered Users 2 Posts: 507 ✭✭✭


    Hi folks,

    Just wondering if anyone has a list of SQL Injection keywords that I could use to filter out of user input.

    Cant find anything decent on google..

    Im using SQL Server BTW...

    Cheers


Comments

  • Closed Accounts Posts: 275 ✭✭Hydrosylator


    Well that depends on what language you're using, which one is it?
    I know SQL is independent of the language, but the functions that can be used aren't.

    Rather than filter every possible exploit, you should use a function like mysql_real_escape_string to stop sql injections.


  • Registered Users, Registered Users 2 Posts: 507 ✭✭✭bigbadcon


    Not sure I understand what you mean?

    Im using asp.net(vb) to connect to a SQL Server 2005 database..


  • Registered Users, Registered Users 2 Posts: 8,700 ✭✭✭jmcc


    bigbadcon wrote: »
    Not sure I understand what you mean?

    Im using asp.net(vb) to connect to a SQL Server 2005 database..
    The standard procedure is to treat every input from the web as being toxic. This means that it is then filtered for various attempts at SQL injection by removing non-text charcters or other elements. I haven't used ASP for years but there should be some routines and procedures for doing this.

    Regards...jmcc

    Regards…jmcc



  • Closed Accounts Posts: 275 ✭✭Hydrosylator


    Ah I see what you mean. Well I know feck all about asp.net but here's a page I found that should get you out of your current bind.

    How To: Protect From SQL Injection in ASP.NET


Advertisement
Advertisement