SQL Injection in Classic ASP and Possible Solutions: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
SQL Injection in Classic ASP and Possible Solutions

page 8 of 8

by Ehsanul Haque
Feedback

Average Rating:

Views (Total / Last 10 Days): 18769/ 403

Article Contents:

Conclusion

A proper validation can keep your website safe from hacking. The solution of this article will centralize the validation logic to sanitize input data so that anytime this logic can modify which will take effect in the whole site even within a sec. Also, this technique will help to protect from not only SQL-injection, but also cross-site scripting (XSS).

« (Page 7)

View Entire Article

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 5 and 2 and type the answer here:

User Comments

Title: Replace wrong words
Name: Eric Coumans
Date: 12/21/2009 10:37:23 AM
Comment:
Hi there,

small question: is it also possible instead of going to the error page, replace the value in the scanned form input?

so when somebody fills in "copenhagen" the function (mentioned above) will change ("open") this into: "c*hagen"...

thanks for the help!

Title: RE: Function always return true
Name: Ehsanul Haque
Date: 12/9/2009 5:01:13 AM
Comment:
Hello Mr. Javed,
I don't think the function is always returning true. After configuring the sample, open the test.asp and type username "cursor p1" and it will be blocked as the "cursor" is the blacklisted keyword. Similarly, if you write "abc" it will not block as it is not in the blacklist. Also see the relavant code below:

For Each s in BlackList
If(IsExceptionList(s,varType)=False) then
If ( InStr (lstr, s) <> 0 ) Then
CheckStringForSQL = true
Exit Function
End If
End If
Next

Where "lstr" is the string to check and "s" is the blacklisted keyword.

However, please check that the sample is configured correctly. Please let me know if I can help you anyway.

Thanks,
Ehsan

Title: Function always return true
Name: Javed Iqbal
Date: 12/9/2009 2:01:23 AM
Comment:
\

Title: RE: 谢谢。
Name: Ehsanul Haque
Date: 12/5/2009 6:40:15 AM
Comment:
Hi,
I don't know Chinese but I think you are looking for code sample. If it is true then please see the entire article here http://aspalliance.com/1703_SQL_Injection_in_Classic_ASP_and_Possible_Solutions.all

Also you can get the sample project by clicking on the Downloads link at the top or browse here http://aspalliance.com/1703_SQL_Injection_in_Classic_ASP_and_Possible_Solutions.all#Page6

Thanks,
Ehsan

Title: Thank you
Name: Stefan
Date: 11/24/2009 11:22:30 AM
Comment:
Thank you very much. I had some SQL injection problems and I implemented this, tested and it seems to hold up thus far.

Now I have to teach myself stored procedures along with some .net stuff. Thanks again.

Title: :)
Name: RJ
Date: 1/13/2009 2:04:18 AM
Comment:
good article. it really helps