Discussions

boolean type

+
0 Votes
Locked

boolean type

seibou123
Let
  • +
    0 Votes
    CharlieSpencer

    I don't know squat about SQL statements, but I try something like

    If value = 0 then value = 1 else value = 0

    But try reposting this in the 'Q&A' forum. The 'Discussion' forum is for matters of general discussion, not specific problems in search of a solution. The 'Water Cooler' is for non-technical discussions. You can submit a question to 'Q&A' here:

    http://www.techrepublic.com/forum/questions/post?tag=mantle_skin;content

    There are TR members who specifically seek out problems in need of a solution. Although there is some overlap between the forums, you'll find more of those members in 'Q&A' than in 'Discussions' or 'Water Cooler'.

    Be sure to use the voting buttons to provide your feedback. Voting a '+' does not necessarily mean that a given response contained the complete solution to your problem, but that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours. If they have a ready source of reference available, perhaps won't need to repeat questions previously asked and answered. If a post did contain the solution to your problem, you can also close the question by marking the helpful post as "The Answer".

    +
    0 Votes
    Slayer_

    Booleans are bad. Use integers instead. It almost always happens that the previous yes/no response isn't good enough.

    Just like how many genders are there. You say male and female.
    Well actually it is
    Male
    Female
    Other

    +
    0 Votes
    Tony Hopkinson

    Update SomeValue = (SomeValue + 1) % 2 Where [Name] = 'SomeName'

    +
    0 Votes
    Slayer_

    I thought % was the wild card.

    +
    0 Votes
    Tony Hopkinson

    Wild card in a Like argument

  • +
    0 Votes
    CharlieSpencer

    I don't know squat about SQL statements, but I try something like

    If value = 0 then value = 1 else value = 0

    But try reposting this in the 'Q&A' forum. The 'Discussion' forum is for matters of general discussion, not specific problems in search of a solution. The 'Water Cooler' is for non-technical discussions. You can submit a question to 'Q&A' here:

    http://www.techrepublic.com/forum/questions/post?tag=mantle_skin;content

    There are TR members who specifically seek out problems in need of a solution. Although there is some overlap between the forums, you'll find more of those members in 'Q&A' than in 'Discussions' or 'Water Cooler'.

    Be sure to use the voting buttons to provide your feedback. Voting a '+' does not necessarily mean that a given response contained the complete solution to your problem, but that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours. If they have a ready source of reference available, perhaps won't need to repeat questions previously asked and answered. If a post did contain the solution to your problem, you can also close the question by marking the helpful post as "The Answer".

    +
    0 Votes
    Slayer_

    Booleans are bad. Use integers instead. It almost always happens that the previous yes/no response isn't good enough.

    Just like how many genders are there. You say male and female.
    Well actually it is
    Male
    Female
    Other

    +
    0 Votes
    Tony Hopkinson

    Update SomeValue = (SomeValue + 1) % 2 Where [Name] = 'SomeName'

    +
    0 Votes
    Slayer_

    I thought % was the wild card.

    +
    0 Votes
    Tony Hopkinson

    Wild card in a Like argument