Revision 2186
Added by Aaron Marcuse-Kubitza over 12 years ago
| lib/sql.py | ||
|---|---|---|
| 472 | 472 |
query += ' WHERE '+(' AND '.join(map(cond, conds.iteritems())))
|
| 473 | 473 |
params += conds.values() |
| 474 | 474 |
missing = False |
| 475 |
if order_by != None: query += ' ORDER BY '+esc_name_(order_by)
|
|
| 475 |
if order_by != None: query += ' ORDER BY '+parse_col(order_by, table0)
|
|
| 476 | 476 |
if limit != None: query += ' LIMIT '+str(limit); missing = False |
| 477 | 477 |
if start != None: |
| 478 | 478 |
if start != 0: query += ' OFFSET '+str(start) |
Also available in: Unified diff
sql.py: put_table(): Fixed bug where ORDER BY column needed to have table0 name prefixed (if it didn't already have a table name), to avoid ambiguous column references