The Daily WTF: Curious Perversions in Information Technology
Welcome to TDWTF Forums Sign in | Join | Help
in Search

Smartphonemag.com

Last post 11-29-2008 6:34 PM by rosko. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 11-29-2008 1:01 AM

    Smartphonemag.com

    I know this is an ancient link, but I can't find a reference on here. 

     I opened http://www.smartphonemag.com/awards_2007/category.asp?catid=45#InternetRelayChat in Firefox 3.0.4, and was greeted by a wall of seemingly control characters, with a few pictures embedded.  Thinking it was a browser issue, I opened it in IE7, which displayed a valid-looking HTML page.  So I decided to look at the page source.  Turns out that it's sending the full ASP source, which Firefox displays as a single line (which is why I didn't recognise it immediately, not on as little sleep as I had last night), IE7 apparently just discards the non-HTML part.

  • 11-29-2008 3:25 AM In reply to

    • Juifeng
    • Top 500 Contributor
    • Joined on 06-10-2006
    • Winnenden, Germany
    • Posts 79

    Re: Smartphonemag.com

     Seems like there are more WTFs to come:

    ' To update this page for 2007 etc., change "Product.Nom2007" in the SQL query to the appropriate field.

     

  • 11-29-2008 5:38 AM In reply to

    Re: Smartphonemag.com

     I wonder how long untill someone alters the page to call ExecuteSQL("DROP TABLE product")

    Damn you furfag!

  • 11-29-2008 9:06 AM In reply to

    • rosko
    • Not Ranked
    • Joined on 09-05-2008
    • Posts 15

    Re: Smartphonemag.com

    And still the WTFs come...

    SELECT TOP 100 PERCENT  ...

    Failure - you can't spell it without U R A
  • 11-29-2008 5:37 PM In reply to

    • zokar
    • Not Ranked
    • Joined on 02-27-2008
    • Posts 3

    Re: Smartphonemag.com

    rosko:

    And still the WTFs come...

    SELECT TOP 100 PERCENT  ...

     

    Not a WTF. Google for it. It is valid syntax, and is apparently recommended in certain circumstances.

  • 11-29-2008 6:34 PM In reply to

    • rosko
    • Not Ranked
    • Joined on 09-05-2008
    • Posts 15

    Re: Smartphonemag.com

    zokar:
    rosko:
    And still the WTFs come...

    SELECT TOP 100 PERCENT  ...

     Not a WTF. Google for it. It is valid syntax, and is apparently recommended in certain circumstances.

    Except that it's a dirty hack to allow views and subqueries to be ordered. It is probably used in the SQL on this page because the developer got an error when trying to do a union of two SQL select statements, not realising that the correct syntax is just to put the order by clause at the end of the statement (as it orders the union, not the parts).

    Failure - you can't spell it without U R A
Page 1 of 1 (6 items)
Powered by Community Server (Non-Commercial Edition), by Telligent Systems