• Timmy (unregistered)

    Dup?

  • someone (unregistered)

    I'm sorry, I'm missing something here. Whats the SQL refrence?

  • SomeoneElse (unregistered) in reply to Timmy
    Timmy:
    Dup?

    Thus the "Classic Week" Title!

    WTF? Can't anyone here read?

  • SomeoneElse (unregistered) in reply to someone
    someone:
    I'm sorry, I'm missing something here. Whats the SQL refrence?

    Look at the jpeg. right after the ingredients listing.

  • Smitty (unregistered) in reply to someone
    someone:
    I'm sorry, I'm missing something here. Whats the SQL refrence?

    its a package you would get in a store. rather than saying like Made from Facility 5, the sql code was returned rather than the data it would of returned. silly!!!

  • Stephen (unregistered) in reply to SomeoneElse

    Haha!

    • may contain sql queries
  • Dustin (unregistered)

    SQL is so 1990s, where's my MDX chocolate?!?

  • barf indeedy (unregistered)

    awesome!!!

  • doof (unregistered)

    Instant classic!

  • (cs)

    Packed in an environment where Gluten, Nuts, Sesame seeds and slightly dodgy SQL code may be present.

    :P

  • (cs) in reply to SomeoneElse
    SomeoneElse:
    Timmy:
    Dup?

    Thus the "Classic Week" Title!

    WTF? Can't anyone here read?

    Perhaps they should idiot-proof it and change the title from Classics Week to We know these have been posted before, but we're re-running some oldies but goodies so please STFU week

  • (cs) in reply to SomeoneElse
    SomeoneElse:
    Timmy:
    Dup?

    Thus the "Classic Week" Title!

    WTF? Can't anyone here read?

    Yes, I love candy!
  • Gavin van (unregistered)

    The real, uh, failure is that they seem to be using an Access DB.

  • (cs)

    Sweet!

  • JCritt (unregistered)

    This one was my favorite. I remember reading it as I was writing a query.

    /captcha smile :D

  • Nick (unregistered)

    lol, thats funny

  • doof (unregistered) in reply to shadowman

    "idiot proof it"

    No, just say: "Classics week! To report dups, bang head here --> * "

  • Griff (unregistered)

    Frito-Lay has a new dip that includes the ingredient DATEM.

    Yeah, I know it is an emusifier, but it always looks like a print code error to me.

  • igitur (unregistered)

    Oh, and just for clarity... we are selecting from a TABLE... SELECT * FROM Equipment just wasn't clear enough.

  • (cs) in reply to igitur
    igitur:
    Oh, and just for clarity... we are selecting from a TABLE... SELECT * FROM Equipment just wasn't clear enough.
    They kept having problems with that syntax. The database server kept instructing the assembly line robots to physicially SELECT pieces of equipment from the room. It wouldn't have been so bad, except that it turned out to be a blocking read, since the robot would lift the equipment from its moorings to indicate its "selected" status.

    The current syntax is scarcely better, though. When one robot Selects the [Equipment Table], the other robots don't have anywhere to put their error printouts before photographing them.

  • (cs) in reply to Stephen
    Stephen:
    * may contain sql queries

    Haha, nice. Anyway, if they're gonna go for "classic" articles, they should go for articles from before this year, no?

  • Bill Joy (unregistered)

    That's not SQL, that's MS SQL and there's a big difference. One's a standard the other is as incompatible with that standard as possible while plausibly retaining the name. It bears a passing resemblance at best.

  • (cs) in reply to shadowman
    shadowman:
    SomeoneElse:
    Timmy:
    Dup?

    Thus the "Classic Week" Title!

    WTF? Can't anyone here read?

    Perhaps they should idiot-proof it and change the title from Classics Week to We know these have been posted before, but we're re-running some oldies but goodies so please STFU week

    Perhaps they could just change is using a find and replace?

    You know, like when you click http://thedailywtfthedailywtfthedailywtf.worsethanfailure.com/Default.aspx

    Note my find, of course, but damn funny.

  • (cs) in reply to Saarus
    Saarus:
    shadowman:
    SomeoneElse:
    Timmy:
    Dup?

    Thus the "Classic Week" Title!

    WTF? Can't anyone here read?

    Perhaps they should idiot-proof it and change the title from Classics Week to We know these have been posted before, but we're re-running some oldies but goodies so please STFU week

    Perhaps they could just change is using a find and replace?

    You know, like when you click http://thedailywtfthedailywtfthedailywtf.worsethanfailure.com/Default.aspx

    Note my find, of course, but damn funny.

    Damn... s/Note/Not/ in previous post.

  • Bryan (unregistered)

    Did anyone else notice the space in the table name and the space in the column name????

  • igitur (unregistered) in reply to Bryan
    Bryan:
    Did anyone else notice the space in the table name and the space in the column name????

    Yip. Not very elegant, but totally permissible, hence the square brackets around the names.

  • Troy Mclure (unregistered) in reply to Bill Joy
    Bill Joy:
    That's not SQL, that's MS SQL and there's a big difference. One's a standard the other is as incompatible with that standard as possible while plausibly retaining the name. It bears a passing resemblance at best.

    I think that allowing spaces in tables/columns is the most horrible idea evar! evar!

  • (cs) in reply to doof
    doof:
    "idiot proof it"

    No, just say: "Classics week! To report dups, bang head here --> * "

    A wise man once taught me: "Don't waste your time trying to make things idiot proof. Instead, aim to make them fool resistant."

  • barf indeedy (unregistered) in reply to Troy Mclure
    Troy Mclure:
    Bill Joy:
    That's not SQL, that's MS SQL and there's a big difference. One's a standard the other is as incompatible with that standard as possible while plausibly retaining the name. It bears a passing resemblance at best.

    I think that allowing spaces in tables/columns is the most horrible idea evar! evar!

    lol, true. But it's not a big difference. Just use the current ansi standards and don't use spaces. voila. (although CTPs are handy)

  • BillyBob (unregistered) in reply to igitur
    igitur:
    Oh, and just for clarity... we are selecting from a TABLE... SELECT * FROM Equipment just wasn't clear enough.

    Huh? What's wrong with this? I know I always do:

    void fooFunction(void);

    struct barStruct;

    class foobarClass;

    int fubarInteger;

    float fuFloat;

    someTypeClass barfooObject;

    On a related note, I also like the following typedefs in C:

    #define ONE 1 #define TWO 2 #define THREE 3 #define FOUR 4

  • BillyBob (unregistered) in reply to BillyBob
    BillyBob:
    On a related note, I also like the following typedefs in C:

    #define ONE 1 #define TWO 2 #define THREE 3 #define FOUR 4

    Obviously too early in the morning as these are clearly not typedefs :-)

  • Sigivald (unregistered)

    Say what, bill?

    If MSSQL isn't standard enough for you, who is?

    IBM and Oracle hardly implement a perfect SQL1999 or SQL2003 either.

    In fact, I don't know that anyone implements a complete "standard" SQL (and if so, which version? 99? 2003? 92? earlier?)

    (Don't like the T-SQL extensions? Nobody's forcing you to use them - MS won't make you, as near as I can tell.)

  • Craig (unregistered) in reply to Sigivald

    Only database I know that even tries to implement something other than SQL_old standard is www.nexusdb.com.

  • Craig (unregistered) in reply to Sigivald
    Sigivald:
    Say what, bill?

    If MSSQL isn't standard enough for you, who is?

    IBM and Oracle hardly implement a perfect SQL1999 or SQL2003 either.

    In fact, I don't know that anyone implements a complete "standard" SQL (and if so, which version? 99? 2003? 92? earlier?)

    (Don't like the T-SQL extensions? Nobody's forcing you to use them - MS won't make you, as near as I can tell.)

    Only database I know that even tries to implement something other than SQL_old standard is www.nexusdb.com.

  • Anonymous (unregistered)

    So, the WTF is that they used SELECT *, instead of enumerating the column names, right?

  • (cs)

    No, the WTF is that SQL code is showing up on packaging.

  • bpk (unregistered) in reply to Serpardum
    Anonymous:
    So, the WTF is that they used SELECT *, instead of enumerating the column names, right?
    Serpardum:
    No, the WTF is that SQL code is showing up on packaging.

    Thanks for enlightening him on that one dude, I think you really made a difference in someone's life today

  • No One (unregistered) in reply to TheRider
    TheRider:
    Sweet!

    Dude!

  • (cs) in reply to Saarus
    Saarus:
    Perhaps they could just change is using a find and replace?

    You know, like when you click http://thedailywtfthedailywtfthedailywtf.worsethanfailure.com/Default.aspx

    Note my find, of course, but damn funny.

    Click... Click... Click... Doesn't do anything.

  • * (unregistered) in reply to No One
    No One:
    TheRider:
    Sweet!

    Dude!

    Sweet!

  • Tarkeel (unregistered) in reply to Sigivald

    Derby is the most SQL compliant DB I've dealt with. IIRC, it's SQL92 they use, but it's been a while so I don't remember.

  • (cs) in reply to SomeoneElse
    SomeoneElse:
    Timmy:
    Dup?

    Thus the "Classic Week" Title!

    WTF? Can't anyone here read?

    Ever get the feeling that some people might be trying to be funny by saying these posts are repeats?

  • damunzy (unregistered) in reply to *

    What's mine say?!?

  • damunzy (unregistered) in reply to *
    *:
    No One:
    TheRider:
    Sweet!

    Dude!

    Sweet!
    What's mine say?

    <That I am an idiot that can't quote correctly ;)>

  • Dave (unregistered) in reply to Gavin van

    Yeah, with the bracketed, space-containing field names, it's got to be Microsoft SQL Server or MS Access. I think the semicolon at the end clinches it for Access.

  • Frost Cat (unregistered) in reply to Smitty
    Smitty:
    someone:
    I'm sorry, I'm missing something here. Whats the SQL refrence?

    its a package you would get in a store. rather than saying like Made from Facility 5, the sql code was returned rather than the data it would of returned. silly!!!

    Would have returned. But other than that, yes.

  • JV (unregistered)

    The wtf for me is, this is all I see:

    Toby Gray, that's just not fair! How come my chocolate covered raisins never come with any SQL?

    Is there supposed to be an image or something? If it's an external link, I'm betting it's Websensed.

    Websense. It so makes me want to get back to work.

  • JohnB (unregistered) in reply to JV
    JV:
    The wtf for me is, this is all I see:
    Toby Gray, that's just not fair! How come my chocolate covered raisins never come with any SQL?

    Is there supposed to be an image or something? If it's an external link, I'm betting it's Websensed.

    Websense. It so makes me want to get back to work.

    I've never tried this but ... apparently you can drop a url into Bablefish's "Translate a Web page" data entry box, select Russian to English and, when the fish translates the page, it doesn't appear to be coming a Websense-banned site.

    I'm just saying.

    (not first; not telling you my captcha; not end-of-file)

  • Travis (unregistered)

    SELECT * FROM comments WHERE article = 'Classics Week: Chocolate Covered SQL'

  • Bob Thebastard in QA (unregistered)

    Wow, if the Quality Control is this good for the packaging, imagine how good the chocolates are!

Leave a comment on “Classics Week: Chocolate Covered SQL ”

Log In or post as a guest

Replying to comment #:

Log Out

« Return to Article