Having problems with sqlite3, getting syntax error?

Question

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

ODiogoSilva · Accepted Answer · 2015-05-07 16:00:13Z

2

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

answered May 7, 2015 at 16:00

ODiogoSilva

2,4141 gold badge21 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Having problems with sqlite3, getting syntax error?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related