Project

General

Profile

« Previous | Next » 

Revision 2186

Added by Aaron Marcuse-Kubitza over 12 years ago

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

View differences:

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