1. We have added a Gift Upgrades feature that allows you to gift an account upgrade to another member, just in time for the holiday season. You can see the gift option when going to the Account Upgrades screen, or on any user profile screen.
    Dismiss Notice

Using 1 or 0 for true/false statements with INSERT INTO

Discussion in 'Mod Creation Help' started by ITcore, Sep 30, 2018.

  1. ITcore

    ITcore Warlord

    Joined:
    Dec 25, 2016
    Messages:
    248
    Gender:
    Male
    Location:
    127.0.0.1
    Does SQL treat 1/0 as true/false with INSERT INTO functions? I keep getting a unique constraint failed at ModifierArguments.ModifierId and ModifierArguments.Name and one of the arguments uses true/false values.
     
  2. Laurana Kanan

    Laurana Kanan Don’t underestimate who I am. Moderator

    Joined:
    Apr 10, 2014
    Messages:
    3,316
    Gender:
    Female
    Location:
    Near the Greatest Snow on Earth
    The type of SQL statement doesn't matter as True/False boolean values are always stored as 1/0.
     
  3. ITcore

    ITcore Warlord

    Joined:
    Dec 25, 2016
    Messages:
    248
    Gender:
    Male
    Location:
    127.0.0.1
    I assumed as much but wanted to cover all my bases. I keep returning the unique constraint failure for ModifierArguments and I'm stumped.

    EDIT: Found it. Had an attach modifier listed twice. Doh.
     
    Last edited: Sep 30, 2018

Share This Page