CODEWITHSUNDEEP
pythondatabasepython-3.xsqlite
Patrik Lippojoki
Patrik Lippojoki

Reputation: 1643

Having problems with sqlite3, getting syntax error?

When using sqlite3's database, I get an error like so:

    File '..\database.py', line 131, in load_player_abilities
      (player.id, ability.id)):

sqlite3.OperationalError: near '=': syntax error

The error I'm getting is coming from the following piece of code:

for ability in player.abilities:
    for level in cursor.execute(
            "SELECT level FROM abilities"
            "WHERE player_id=? AND ability_id=?",
            (player.id, ability.id)):
        ability.level = level

Upvotes: 0

Views: 46

Answers (1)

ODiogoSilva
ODiogoSilva

Reputation: 2414

It seems you are missing a space between abilities and WHERE.

for ability in player.abilities:
    for level in cursor.execute(
        "SELECT level FROM abilities "
        "WHERE player_id=? AND ability_id=?",
        (player.id, ability.id)):
        ability.level = level

Upvotes: 2

Related Questions