• Leo (unregistered)
    Comment held for moderation.
  • fahadsadah (unregistered)

    YearValue DisplayName ReferenceID deleted frist frist frist 0

  • Milligan (unregistered)

    State tables usually have more than 50 rows, unless you are determined to leave out Washington, DC and the military designations (AP, FP, etc.) Also in many cases they include places like Guam and American Samoa.

  • fahadsadah (unregistered)

    Err... nearly

    CAPTCHA last time was minim, and this time ascii

  • What? It worked??? (unregistered)

    Okay, this starts to become ridiculous. Why has nobody so far managed to post?

    By the way, according to NMA, there are 51 states since about 25 years.

  • I wonder if jan ever sent him his check? (unregistered)

    Note to self: Disable auto-save in database editor

  • Someone (unregistered)

    SenderRecordEmployeeNameWhoPerformedTheLastChangeInGunship "Gunship"? is that really that sensitive? At least, that what the crossed-out part looks like to me.

  • Mr. G (unregistered) in reply to Milligan
    Milligan:
    State tables usually have more than 50 rows, unless you are determined to leave out Washington, DC and the military designations (AP, FP, etc.) Also in many cases they include places like Guam and American Samoa.

    Don't even get me started about State tables including those crazy Canadian provinces too. AB, YK... What kind of abbreviations are those?

  • John Rasch (cs) in reply to What? It worked???

    There was an issue with the NIC configuration on the server that brought it down earlier and was fixed before I got in. Apparently the DNS IPs were modified in the process, but I've changed them back.

    Without DNS, there is no way to resolve rest.akismet.com (the spam filter service). The system doesn't seem to like allowing comments when contacting this service fails :)

  • Someone else (unregistered) in reply to Someone
    Someone:
    SenderRecordEmployeeNameWhoPerformedTheLastChangeInGunship "Gunship"? is that really that sensitive? At least, that what the crossed-out part looks like to me.

    Oh no! You've circumvented the RedactSensitiveInformationTheTSAWay function!

  • RHuckster (cs)

    I wonder if Joe got his Viagra meds?

    Hello?

    This is the stupidest IM client ever.

  • Xenon Xavior (unregistered)

    I believe that row 51 is akin to area 51. The poster of this image and all who have seen it will be systematically eliminated by the govern... dies suddenly

  • bored (unregistered)

    I like how they put a Select One or Choose One or Please Select from Dropdown, actually IN the database.

  • Quirkafleeg (unregistered)

    Frist! (I hope. After the 10 millionth attempt to submit this. Database oddity?)

    Oh, and why are some of the images JPEGs? Submitted that way? (Just asking. It sort of sticks out a mile that they should initially have been PNGs or GIFs…)

  • weff (unregistered)

    i wonder if tdwtf ever posted my comment?

  • Anonymous (unregistered)

    I had a great comment but the moment has passed now. Then I had a somewhat crappier comment about how I originally had a great comment. That got deleted. Now I'm feeling really insecure and more than anything I just want to get involved in this discussion but you're just going to keep on deleting my posts until finally I have to KILL MYSELF. Is that seriously what you people want? I just want to be accepted, don't allow me to die alone...

  • Quirkafleeg (unregistered) in reply to Quirkafleeg

    Ha. I wander off for twenty minutes and 10 million (well, 15) other comments appear. Oh well. If I ever visit the USA, I'll try to make sure that I go to Select One.

  • Anon (unregistered) in reply to Xenon Xavior
    Xenon Xavior:
    I believe that row 51 is akin to area 51. The poster of this image and all who have seen it will be systematically eliminated by the govern... *dies suddenly*

    KNIGHT: What does it say? MAYNARD: It reads, 'Here may be found the last words of Joseph of Aramathea. He who is valiant and pure of spirit may find the Holy Grail in the Castle of uuggggggh'. ARTHUR: What? MAYNARD: '... the Castle of uuggggggh'. BEDEMIR: What is that? MAYNARD: He must have died while carving it. LAUNCELOT: Oh, come on! MAYNARD: Well, that's what it says. ARTHUR: Look, if he was dying, he wouldn't bother to carve 'aaggggh'. He'd just say it! MAYNARD: Well, that's what's carved in the rock! GALAHAD: Perhaps he was dictating. ARTHUR: Oh, shut up. Well, does it say anything else? MAYNARD: No. Just, 'uuggggggh'.

  • Bluebell (unregistered) in reply to Anonymous
    Anonymous:
    I had a great comment but the moment has passed now. Then I had a somewhat crappier comment about how I originally had a great comment. That got deleted. Now I'm feeling really insecure and more than anything I just want to get involved in this discussion but you're just going to keep on deleting my posts until finally I have to KILL MYSELF. Is that seriously what you people want? I just want to be accepted, don't allow me to die alone...
    Quoted for posterity. You will not be silenced my friend!
  • Populus (unregistered)

    TRWTF on the state table is that they used a 4 byte int as the primary key of 4 bytes instead of a 2 byte char.

  • Zapp Brannigan (unregistered) in reply to Anonymous
    Anonymous:
    I had a great comment but the moment has passed now. Then I had a somewhat crappier comment about how I originally had a great comment. That got deleted. Now I'm feeling really insecure and more than anything I just want to get involved in this discussion but you're just going to keep on deleting my posts until finally I have to KILL MYSELF. Is that seriously what you people want? I just want to be accepted, don't allow me to die alone...
    In the end, we all die alone.
  • Blue Collar (unregistered) in reply to Zapp Brannigan
    Zapp Brannigan:
    Anonymous:
    I had a great comment but the moment has passed now. Then I had a somewhat crappier comment about how I originally had a great comment. That got deleted. Now I'm feeling really insecure and more than anything I just want to get involved in this discussion but you're just going to keep on deleting my posts until finally I have to KILL MYSELF. Is that seriously what you people want? I just want to be accepted, don't allow me to die alone...
    In the end, we all die alone.

    Unless you die in a plane crash... then you'll have company.

  • MOH (unregistered) in reply to Someone
    Someone:
    SenderRecordEmployeeNameWhoPerformedTheLastChangeInGunship "Gunship"? is that really that sensitive? At least, that what the crossed-out part looks like to me.

    Nonsense. It clearly says bunslip.

  • Jackson Curtis (unregistered)

    I'm pretty sure the designer of the year table was smart enough to know there was no need to support 2013.

  • peet (unregistered)

    Having year-tables is perfectly ok, if each of those year-rows in that table have some special state in some special context. It looks strange, but it might be reasonable in some cases.

  • dssg (unregistered)

    The year table was populated by Mayans.

  • ctardi (cs) in reply to peet
    peet:
    Having year-tables is perfectly ok, if each of those year-rows in that table have some special state in some special context. It looks strange, but it might be reasonable in some cases.

    I tend to use them in the context of things that are called the '2010' year, but really start at some randomly determined point in 2009, and end at another random point in 2010, therefor needing some kind of a 'state' determination of the current year. Makes sense...

  • Outtascope (unregistered) in reply to Zapp Brannigan
    Zapp Brannigan:
    Anonymous:
    I had a great comment but the moment has passed now. Then I had a somewhat crappier comment about how I originally had a great comment. That got deleted. Now I'm feeling really insecure and more than anything I just want to get involved in this discussion but you're just going to keep on deleting my posts until finally I have to KILL MYSELF. Is that seriously what you people want? I just want to be accepted, don't allow me to die alone...
    In the end, we all die alone.

    Not true my friend. Now personally, I just want to go quietly in my sleep like my Grandpa. Not like the four other people riding in the car with him.

    captcha appellatio: What Granny Smith does to Jonathan?

  • Spoe (unregistered)

    Clearly the Mayans created the Year table and they just knew it was pointless to add 2013.

  • Blue Collar (unregistered) in reply to Outtascope
    Outtascope:
    Zapp Brannigan:
    Anonymous:
    I had a great comment but the moment has passed now. Then I had a somewhat crappier comment about how I originally had a great comment. That got deleted. Now I'm feeling really insecure and more than anything I just want to get involved in this discussion but you're just going to keep on deleting my posts until finally I have to KILL MYSELF. Is that seriously what you people want? I just want to be accepted, don't allow me to die alone...
    In the end, we all die alone.

    Not true my friend. Now personally, I just want to go quietly in my sleep like my Grandpa. Not like the four other people riding in the car with him.

    captcha appellatio: What Granny Smith does to Jonathan?

    I will go out on a limb here and assume grandpa is driving said car...

    captcha facilisis: What Granny Smith gets from Jonathan?

  • Kef Schecter (unregistered) in reply to Leo
    Comment held for moderation.
  • KattMan (cs)

    The last one, dear lord.

    All of their queries must be like the following: Select * from Table Order by 1,2,3

    and then referencing all fields by ordinal position.

    There is no way I would want to maintain something like that.

  • KattMan (cs)

    The last one, dear lord.

    All of their queries must be like the following: Select * from Table Order by 1,2,3

    and then referencing all fields by ordinal position.

    There is no way I would want to maintain something like that.

  • warmachine (cs)
  • Scott Simmons (unregistered)
    I like how they put a Select One or Choose One or Please Select from Dropdown, actually IN the database.
    I'm a bit surprised if something like this hasn't shown up on this site before. I know that I've seen many, many examples ... It's a popular 'lazy coder' trick, where you set the default value of the dropdown to the 'Select One' entry on the source table, and then include a check that the value has been changed to something else when you validate on submission. It's ugly and lazy, but the thought process behind it is relatively comprehensible.

    Well, compared to some of the things I've seen on this site, anyway.

  • jmucchiello (cs)

    Year tables are quite common for reporting purposes. But they usually only have one column "Year". And why in the world would a year be deleted? Nope, we don't need 2004 any more. Just delete it.

  • jordanwb (unregistered) in reply to jmucchiello
    jmucchiello:
    Year tables are quite common for reporting purposes. But they usually only have one column "Year". And why in the world would a year be deleted? Nope, we don't need 2004 any more. Just delete it.

    In that one episode of the Dilbert TV series they skipped year 2000 due to the Y2K bug.

  • Aaron (unregistered)

    I'll be the "i wonder if jan..." column name was the result of someone not noticing that their IM client no longer had focus.

  • Zylon (cs) in reply to Blue Collar
    Blue Collar:
    Outtascope:
    Not true my friend. Now personally, I just want to go quietly in my sleep like my Grandpa. Not like the four other people riding in the car with him.

    captcha appellatio: What Granny Smith does to Jonathan?

    I will go out on a limb here and assume grandpa is driving said car...
    Outtascope mangled the joke. Original version here.

  • Some Wonk (unregistered) in reply to MOH
    MOH:
    Someone:
    SenderRecordEmployeeNameWhoPerformedTheLastChangeInGunship "Gunship"? is that really that sensitive? At least, that what the crossed-out part looks like to me.

    Nonsense. It clearly says bunslip.

    Bank Teller #1: Does this look like "gub" or "gun"? Bank Teller #2: Gun. See? But what does "abt" mean? Virgil: It's "act". A-C-T. Act natural. Please put fifty thousand dollars into this bag and act natural. Bank Teller #1: Oh, I see. This is a holdup?

  • JV (unregistered) in reply to Scott Simmons
    Scott Simmons:
    I like how they put a Select One or Choose One or Please Select from Dropdown, actually IN the database.
    I'm a bit surprised if something like this hasn't shown up on this site before. I know that I've seen many, many examples ... It's a popular 'lazy coder' trick, where you set the default value of the dropdown to the 'Select One' entry on the source table, and then include a check that the value has been changed to something else when you validate on submission. It's ugly and lazy, but the thought process behind it is relatively comprehensible.

    Well, compared to some of the things I've seen on this site, anyway.

    I'll admit that I've done this myself. My "Select Item from Table Order By ID" would return an array of strings that I can use to populate the pull-down directly. It seems kinda silly to copy that array[n] to a new array[n+1] element-by-element just so that the first element can be "Select One".
  • snoofle (cs) in reply to Blue Collar
    Blue Collar:
    Outtascope:
    Zapp Brannigan:
    Anonymous:
    I had a great comment but the moment has passed now. Then I had a somewhat crappier comment about how I originally had a great comment. That got deleted. Now I'm feeling really insecure and more than anything I just want to get involved in this discussion but you're just going to keep on deleting my posts until finally I have to KILL MYSELF. Is that seriously what you people want? I just want to be accepted, don't allow me to die alone...
    In the end, we all die alone.

    Not true my friend. Now personally, I just want to go quietly in my sleep like my Grandpa. Not like the four other people riding in the car with him.

    captcha appellatio: What Granny Smith does to Jonathan?

    I will go out on a limb here and assume grandpa was driving said car...

    captcha facilisis: What Granny Smith gets from Jonathan?

    FTFY

  • Stephen (unregistered)

    The world's ending in 2012 anyway.

  • hoodaticus (cs) in reply to Leo
    Leo:
    According to Barack Obama, you're still missing 6 states.

    Not so! Obama said he'd been to 57 states, with one to go!

    This, from a sitting Senator.

  • me (unregistered) in reply to Stephen
    Stephen:
    The world's ending in 2012 anyway.

    That's what the movie told me anyway...

  • gl (unregistered)

    2004 was a bad year for me.

    Luckily we can delete it.

    captcha odio: Ohio on a bad day.

  • Sumrnot (unregistered) in reply to Aaron

    I was thinking more along the lines of a time bomb tucked away in the code.

  • Someone You Know (cs) in reply to JV
    JV:
    It seems kinda silly to copy that array[n] to a new array[n+1] element-by-element just so that the first element can be "Select One".

    http://en.wikipedia.org/wiki/Linked_list

  • duder (unregistered) in reply to Aaron
    Aaron:
    I'll be the "i wonder if jan..." column name was the result of someone not noticing that their IM client no longer had focus.

    I'll bet that the "i wonder if jan.." column name was the result of someone not receiving said check from jan in a sufficiently expedient time frame.

  • ContraCorners (cs) in reply to hoodaticus
    hoodaticus:
    Leo:
    According to Barack Obama, you're still missing 6 states.

    Not so! Obama said he'd been to 57 states, with one to go!

    This, from a sitting Senator.

    I love how everyone jumps on this video to say "Obama says there are 57 states." HE SAID NO SUCH THING.

    Listen carefully. He says quite clearly that there are 60 states! He visited 57, with one to go (that makes 58) plus Alaska and Hawaii that he wasn't allowed to go to (58+2 = 60)!

    Does anyone know of a link where we can here the context for this? I've only ever heard these few seconds. Often what comes before and after explains what the speaker is trying to say, but for this clip I've never found the before and after.

    In all liklihood he meant to say 47 with one to go plus Alaska and Hawaii to make 50, but who knows?

    (Lucky me... comment #51)

Leave a comment on “The Year Table, Row 51, and other Database Oddities”

Log In or post as a guest

Replying to comment #:

« Return to Article