Menu

#4385 (ok 4.2.1) Grid edit on sorted columns fails

4.2.0
fixed
1
2014-05-16
2014-05-06
Benjam
No

When a table is sorted, and an attempt is made to edit a value in the column that is sorted, the query that is generated has the sort order number as part of the column name.

e.g.- for the foo column, it's been sorted 'desc', and so gets an arrow and a sort order number '1' in the column header.
When I try to edit a value in that column, the query that gets created is thus:
UPDATE `db`.`table` SET `foo 1` = '0' WHERE `table`.`id` = 1

Note the space in the column name of the SET clause.
This obviously throws an error and is not what's expected.

Discussion

  • Marc Delisle

    Marc Delisle - 2014-05-06
    • Group: Latest_Git --> 4.2.0
     
  • Marc Delisle

    Marc Delisle - 2014-05-06
    • assigned_to: Marc Delisle
     
  • Marc Delisle

    Marc Delisle - 2014-05-06
    • summary: Grid edit on sorted columns fails --> (ok 4.2.1) Grid edit on sorted columns fails
    • status: open --> resolved
    • Priority: 5 --> 1
     
  • Marc Delisle

    Marc Delisle - 2014-05-16
    • status: resolved --> fixed