Re: Able to run statement in CLI and return a correct value but when run in a script it returns None

[Peter Brawley]

Apologies, on first read I missed two likely problems ...

> WHERE Token = '" + (data['data'][coin]['symbol'] + "'")

1 The first double quote encloses nothing, the second encloses a single quote. That should generate a MySQL syntax error.

2 In MySQL, the + operator does not concatenate strings, it just adds numeric values. You need to use Concat(). eg ...

... WHERE Token = concat( ''", data['data'][coin]['symbol'], "'") ...

If the Python code had included error-trapping code, you might've seen a useful error or warning msg.