• David S. (unregistered)

    This is to avoid magic strings! They are the bane of our existence!

  • cynical cynic (unregistered)

    Cue FILE_NOT_FOUND joke in 3..2..1..

  • I'll bite (unregistered) in reply to cynical cynic

    They missed FileNotFoundException surley?

  • Scott (unregistered)

    Silly, you need to move that into a table to make it more easily extensible.

    SELECT valueId, ValueContent FROM YesNoOptions;
  • Death (unregistered) in reply to Scott
    Scott:
    Silly, you need to move that into a table to make it more easily extensible. 
    SELECT valueId, ValueContent FROM YesNoOptions;

    Exacty! You never know when business people start demanding a Maybe option.

  • (cs) in reply to Death
    Death:
    Scott:
    Silly, you need to move that into a table to make it more easily extensible. 
    SELECT valueId, ValueContent FROM YesNoOptions;

    Exacty! You never know when business people start demanding a Maybe option.

    "Start"?

    I've worked on Wall Street for more than 20 years, and every single trading system I've encountered had a certain sense of randomness depending upon in what order what prices from which exchanges/ECN's were checked against the others. "Maybe" is a way of life!

  • (cs) in reply to Death
    Death:
    Scott:
    Silly, you need to move that into a table to make it more easily extensible. 
    SELECT valueId, ValueContent FROM YesNoOptions;

    Exacty! You never know when business people start demanding a Maybe option.

    Feh, they were just planning ahead to ensure that in the future they could support an additional bazillion degrees of surety between Yes and No.

    Of course, they've screwed the pooch by not setting Yes as the max BIGINT value...

  • sakasune (unregistered) in reply to Death

    Actually I had to do something like that...there were three possible choices and my manager demanded they be in a table...

    ID | Text 1 | Yes 2 | No 3 | Unavailable

    sigh

  • XXXX (unregistered) in reply to sakasune
    sakasune:
    Actually I had to do something like that...there were three possible choices and my manager demanded they be in a table...

    ID | Text 1 | Yes 2 | No 3 | Unavailable

    sigh

    4 | File Not Found

  • Bill P. Godfrey (unregistered)

    Files on embedded systems! Bert Glanstrom! Wooden Table!

  • (cs) in reply to XXXX
    XXXX:
    sakasune:
    Actually I had to do something like that...there were three possible choices and my manager demanded they be in a table...

    ID | Text 1 | Yes 2 | No 3 | Unavailable

    sigh

    4 | File Not Found
    That's 'unavailable'. No need to put the same Boolean twice in the same table. Three values for a Boolean is more than enough.

  • trwtf (unregistered) in reply to Severity One
    Severity One:
    XXXX:
    sakasune:
    Actually I had to do something like that...there were three possible choices and my manager demanded they be in a table...

    ID | Text 1 | Yes 2 | No 3 | Unavailable

    sigh

    4 | File Not Found
    That's 'unavailable'. No need to put the same Boolean twice in the same table. Three values for a Boolean is more than enough.

    Enough? You might be in Europe for all I know, but we're Americans here. There's no such word as "enough"!

    5 | Haven't Got Around To Looking Yet 6 | It's Around Here Somewhere 7 | Did You Ask Jane? She Had It A While Ago

  • XXXX (unregistered) in reply to trwtf
    trwtf:
    Severity One:
    XXXX:
    sakasune:
    Actually I had to do something like that...there were three possible choices and my manager demanded they be in a table...

    ID | Text 1 | Yes 2 | No 3 | Unavailable

    sigh

    4 | File Not Found
    That's 'unavailable'. No need to put the same Boolean twice in the same table. Three values for a Boolean is more than enough.

    Enough? You might be in Europe for all I know, but we're Americans here. There's no such word as "enough"!

    5 | Haven't Got Around To Looking Yet 6 | It's Around Here Somewhere 7 | Did You Ask Jane? She Had It A While Ago

    8|NO 9|no 10|yes 11|yEs

  • (cs) in reply to XXXX
    XXXX:
    trwtf:
    Severity One:
    XXXX:
    sakasune:
    Actually I had to do something like that...there were three possible choices and my manager demanded they be in a table...

    ID | Text 1 | Yes 2 | No 3 | Unavailable

    sigh

    4 | File Not Found
    That's 'unavailable'. No need to put the same Boolean twice in the same table. Three values for a Boolean is more than enough.

    Enough? You might be in Europe for all I know, but we're Americans here. There's no such word as "enough"!

    5 | Haven't Got Around To Looking Yet 6 | It's Around Here Somewhere 7 | Did You Ask Jane? She Had It A While Ago

    8|NO 9|no 10|yes 11|yEs

    12|On Alternate Tuesdays 13|Very Yes 14|Very No 15|Very Unavailable

  • Bruce W (unregistered) in reply to webrunner
    webrunner:
    XXXX:
    trwtf:
    Severity One:
    XXXX:
    sakasune:
    Actually I had to do something like that...there were three possible choices and my manager demanded they be in a table...

    ID | Text 1 | Yes 2 | No 3 | Unavailable

    sigh

    4 | File Not Found
    That's 'unavailable'. No need to put the same Boolean twice in the same table. Three values for a Boolean is more than enough.

    Enough? You might be in Europe for all I know, but we're Americans here. There's no such word as "enough"!

    5 | Haven't Got Around To Looking Yet 6 | It's Around Here Somewhere 7 | Did You Ask Jane? She Had It A While Ago

    8|NO 9|no 10|yes 11|yEs

    12|On Alternate Tuesdays 13|Very Yes 14|Very No 15|Very Unavailable

    16|Hell No 17|Huh?

  • sakasune (unregistered) in reply to webrunner

    16|A little from column A, a little from column B 17|NULL 18|All of the above

  • mjfgates (unregistered)

    100 Outlook Murky, Try Again 101 Signs Point To Yes -382 We Got Some Bad Acid Here FNRT AHHHH SPIDERS

  • Bruce W (unregistered) in reply to mjfgates

    42 Depends on what the definition of 'is' is 9999 Dude, what was the question?

  • tim (unregistered)

    sorry guys, fact is stranger than fiction:

    http://msdn.microsoft.com/en-us/library/aa432714(office.12).aspx

  • sakasune (unregistered) in reply to Bruce W

    that should be 420 | dude, what was the question?

  • SR (unregistered) in reply to Bill P. Godfrey
    Bill P. Godfrey:
    Files on embedded systems! Bert Glanstrom! Wooden Table!

    Irish! Girl!

  • sakasune (unregistered) in reply to tim
    tim:
    sorry guys, fact is stranger than fiction:

    http://msdn.microsoft.com/en-us/library/aa432714(office.12).aspx

    I could have used that...and I love how three of them "not supported"

  • (cs) in reply to SR
    SR:
    Bill P. Godfrey:
    Files on embedded systems! Bert Glanstrom! Wooden Table!

    Irish! Girl!

    Brillant?

  • (cs)

    19 | Yes, by statute, but woe betide you if you actually ask for it!

  • (cs) in reply to sakasune
    sakasune:
    16|A little from column A, a little from column B 17|NULL 18|All of the above
    20|xxxxxxxxx 21|Profit!
  • sakasune (unregistered) in reply to JamesQMurphy
    JamesQMurphy:
    sakasune:
    16|A little from column A, a little from column B 17|NULL 18|All of the above
    20|xxxxxxxxx 21|Profit!

    22| This option intentionally left blank

  • (cs)

    Easily extensible for i18n support:

    19|Oui 20|Non 21|Sí 22|No 23|Ja 24|Nein

  • M. Webster (unregistered) in reply to sakasune
    sakasune:
    tim:
    sorry guys, fact is stranger than fiction:

    http://msdn.microsoft.com/en-us/library/aa432714(office.12).aspx

    I could have used that...and I love how three of them "not supported"

    "To use the MsoTriState enumerations in a WSF job..."

    I think they misspelled "WTF".

  • Files on embedded systems! Bert Glanstrom! Wooden Table! (unregistered) in reply to Bill P. Godfrey

    Yes? What do you want?

  • by (unregistered)

    MOAR XML! And VB, and, and... moar of the phps too...

    I don't see the problem with this. Seems very Enterprise-ey (TM) to me.

  • Dan (unregistered) in reply to Death
    Death:
    Scott:
    Silly, you need to move that into a table to make it more easily extensible. 
    SELECT valueId, ValueContent FROM YesNoOptions;

    Exacty! You never know when business people start demanding a Maybe option.

    or a "Yes and No" option or a "Yes Yes" option: I mean the choices are practically endless

  • unekdoud (unregistered)

    You don't understand! Yes and No are aliases for binary digits. Thus: Yes+Yes=YesNo YesNoYesNo-YesYesNo=YesNoNo YesYesYes*YesNoYes=YesNoNoYesYes YesYesYesYesNoNoYesYes+YesNoYesNoYesNoYesYesNo=YesYesYesYesNoNoYesNoNoYes And so on, up to 2^63 or so.

  • Gert (unregistered)

    Actually to get into this seriously, for reporting purposes where you want to display a string instead of a number, this is probably the fastest way (with large recordsets).

    Although I do agree that a fixed table is even more better for that, but it's quicker to join this (virtual) table then use case when's in the query. A lot of case when's make the query slow.

  • Scott (unregistered) in reply to Rootbeer

    Or you could add another column for localization. (EN,En,eN,en,FR,Fr,fR,fr, ....)

  • monkeyPushButton (unregistered) in reply to Someone You Know
    Someone You Know:
    SR:
    Bill P. Godfrey:
    Files on embedded systems! Bert Glanstrom! Wooden Table!

    Irish! Girl!

    Brillant?

    I have Xed your Y, pray I don't ...etc.

    AHHHH!!! Seeing all this together made a horrible image run through my head. Bert Glasnstrom with Irish Girl being "brilant" on a wooden table. Excuse me while I go bleach my brain.

  • CoderHero (unregistered) in reply to monkeyPushButton
    monkeyPushButton:
    Someone You Know:
    SR:
    Bill P. Godfrey:
    Files on embedded systems! Bert Glanstrom! Wooden Table!

    Irish! Girl!

    Brillant?

    I have Xed your Y, pray I don't ...etc.

    AHHHH!!! Seeing all this together made a horrible image run through my head. Bert Glasnstrom with Irish Girl being "brilant" on a wooden table. Excuse me while I go bleach my brain.

    Wasn't this what happened in the movie "Office Space"?

  • by (unregistered) in reply to monkeyPushButton
    monkeyPushButton:
    Someone You Know:
    SR:
    Bill P. Godfrey:
    Files on embedded systems! Bert Glanstrom! Wooden Table!

    Irish! Girl!

    Brillant?

    I have Xed your Y, pray I don't ...etc.

    AHHHH!!! Seeing all this together made a horrible image run through my head. Bert Glasnstrom with Irish Girl being "brilant" on a wooden table. Excuse me while I go bleach my brain.

    You have brain bleach?! I could've used that every time I heard Sarah Palin speaking; instead, I would repeatedly smash my head into the corner of a wall until I found myself waking up on a gurney in an ER... Ahh, memories...

    Where was I going with this again?

  • Neo (unregistered) in reply to tim
    tim:
    sorry guys, fact is stranger than fiction:

    http://msdn.microsoft.com/en-us/library/aa432714(office.12).aspx

    Excellent. A tri-state boolean with five possible values, two of which are actually supported. I think we have a winner.

  • (cs)

    25: Actually No, but to save face, Yes

  • FuBar (unregistered) in reply to sakasune
    sakasune:
    16|A little from column A, a little from column B 17|NULL 18|All of the above
    19.5|WTF? 666|All your beast are belong to us. Over 9000|Meme is stale
  • airdrik (unregistered)

    To best ensure that the future will remain flexible, while still retaining usability, the schema needs to be extended with a BooleanValue field as follows:

    ID | BooleanValue | Value
0  | "False"      | "No"
1  | "False"      | "no"
2  | "False"      | "NO"
3  | "False"      | "NO!"
4  | "False"      | "NO!!"
5  | "False"      | "False"
6  | "False"      | "false"
7  | "False"      | "FALSE"
8  | "False"      | "FALSE!"
9  | "False"      | "FALSE!!"
10 | "False"      | "HECK NO!"
11 | "False"      | "Nein"
12 | "False"      | "Nao"
13 | "False"      | "Zero"
14 | "False"      | "Non"
15 | "True"       | "Yes"
16 | "True"       | "yes"
17 | "True"       | "YES"
18 | "True"       | "YES!"
19 | "True"       | "True"
20 | "True"       | "true"
21 | "True"       | "TRUE"
22 | "True"       | "TRUE!"
23 | "True"       | "HECK YES!"
24 | "True"       | "For Sure"
25 | "Maybe"      | "Maybe"
26 | "Maybe"      | "maybe"
27 | "Maybe"      | "Unavailable"
28 | "Maybe"      | "unavailable"
29 | "Maybe"      | "42"
30 | "True"       | "43"
31 | "True"       | "is"
32 | "True"       | "Is"
33 | "True"       | "IS"
34 | "False"      | "isn't"
35 | "False"      | "Isn't"
36 | "False"      | "ISN'T"
37 | "False"      | "isnt"
38 | "False"      | "Isnt"
39 | "Maybe"      | "ISNT"
40 | "True"       | "Sim"
41 | "True"       | "Ja"
42 | "False"      | "null"
43 | "False"      | "NULL"
44 | "False"      | "Null"

    Captcha: enim - an enum which shouldn't be.

  • airdrik (unregistered) in reply to Zylon
    Zylon:
    25: Actually No, but to save face, Yes
    We actually had an interview candidate some time ago who answered similar to this - I'm going to say No, but I'm leaning more towards Yes, or something similar.
  • Hailey (unregistered)

    69|No, but if you act like a jerk and look like a drunk biker, I really mean Yes.

    70|Yes, I'll go out with you... someday... but tonight I have to organize my spice cabinet. Ask me again sometime. Really!

  • Gary (unregistered) in reply to Neo
    Neo:
    tim:
    sorry guys, fact is stranger than fiction:

    http://msdn.microsoft.com/en-us/library/aa432714(office.12).aspx

    Excellent. A tri-state boolean with five possible values, two of which are actually supported. I think we have a winner.

    It's for the embedded Windows CE drivers inside the Holy Hand Grenade of Antioch.

  • George (unregistered) in reply to Gary
    Gary:
    Neo:
    tim:
    sorry guys, fact is stranger than fiction:

    http://msdn.microsoft.com/en-us/library/aa432714(office.12).aspx

    Excellent. A tri-state boolean with five possible values, two of which are actually supported. I think we have a winner.

    It's for the embedded Windows CE drivers inside the Holy Hand Grenade of Antioch.

    FEATURED COMMENT!

  • (cs) in reply to Neo
    Neo:
    tim:
    sorry guys, fact is stranger than fiction:

    http://msdn.microsoft.com/en-us/library/aa432714(office.12).aspx

    Excellent. A tri-state boolean with five possible values, two of which are actually supported. I think we have a winner.

    Even the values are totally mystic !

    What. The. Fuck.

  • Jay (unregistered) in reply to tim
    tim:
    sorry guys, fact is stranger than fiction:

    http://msdn.microsoft.com/en-us/library/aa432714(office.12).aspx

    As there are 5 possible values, shouldn't it be a "pentastate boolean"?

  • counter-point (unregistered) in reply to by
    by:
    monkeyPushButton:
    Someone You Know:
    SR:
    Bill P. Godfrey:
    Files on embedded systems! Bert Glanstrom! Wooden Table!

    Irish! Girl!

    Brillant?

    I have Xed your Y, pray I don't ...etc.

    AHHHH!!! Seeing all this together made a horrible image run through my head. Bert Glasnstrom with Irish Girl being "brilant" on a wooden table. Excuse me while I go bleach my brain.

    You have brain bleach?! I could've used that every time I heard Sarah Palin speaking; instead, I would repeatedly smash my head into the corner of a wall until I found myself waking up on a gurney in an ER... Ahh, memories...

    Where was I going with this again?

    I actively need it for every time Obama comes up with some "new" idea! Government is great and most efficient! All hail our overlo^w leader! He (they) knows how to run our lives better than we do!

    /nice... the captcha is decet -> deceipt

  • trwtf (unregistered) in reply to Jay
    Jay:
    tim:
    sorry guys, fact is stranger than fiction:

    http://msdn.microsoft.com/en-us/library/aa432714(office.12).aspx

    As there are 5 possible values, shouldn't it be a "pentastate boolean"?

    No, a pentastate boolean would have seven possible values.

  • trwtf (unregistered) in reply to Jay
    Jay:
    tim:
    sorry guys, fact is stranger than fiction:

    http://msdn.microsoft.com/en-us/library/aa432714(office.12).aspx

    As there are 5 possible values, shouldn't it be a "pentastate boolean"?

    No, a pentastate boolean has seven possible values.

Leave a comment on “YesNo”

Log In or post as a guest

Replying to comment #:

Log Out

« Return to Article