sqlite3 operational error on insert query

[jonesin1974]

Interesting as when I try it on a smaller table with only a few fields it works and that was all on one line.

However, I initially had it on one line and it comes back with 'Programming Error'. When I hover over the line (when it's as one line), it says: PEP 8:line too long (570 > 120 characters).

This is really annoying as if it would just let me run the query without all of this (?,?,?) malarkey, I would be OK....probably ;)

Cheers,
Me

---

Right, got there via another source. Turns out I need to use all single quotes and it's fine:

cur.execute(
                'insert into lr_rundata (current_date, test_name, app_version, test_run_period, transaction_name, ' \
                'sla_status, minimum, average, maximum, std_deviation, percentile80, percentile81, percentile82, percentile83, percentile84, ' \
                'percentile85, percentile86, percentile87, percentile88, percentile89, percentile90, percentile91, percentile92, percentile93,' \
                'percentile94, percentile95, percentile96, percentile97, percentile98, percentile99, pass, fail, stop, deleted) values ' \
                '(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)', sql_formatted)