Changes between Version 1 and Version 2 of Ticket #5553
- Timestamp:
- Feb 2, 2012, 11:15:07 PM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #5553 – Description
v1 v2 5 5 #!python 6 6 cursor.execute("SELECT id, name, notes, sort, timestamp, deleted " 7 8 7 "FROM downloader_category " 8 "WHERE id = %s", (id,)) 9 9 }}} 10 10 11 This will break near id = %sbecause you need to specify the table where ID resides. Something like this:11 This will break near `id = %s` because you need to specify the table where ID resides. Something like this: 12 12 13 {{{ 14 #!python 13 15 cursor.execute("SELECT id, name, notes, sort, timestamp, deleted " 14 "FROM downloader_category " 15 "WHERE downloader_category.id = %s", (id,)) 16 "FROM downloader_category " 17 "WHERE downloader_category.id = %s", (id,)) 18 }}} 16 19 17 20 I have changed all the syntax and now works ok.