Ticket #25 (closed Bug: fixed)

Opened 19 months ago

Last modified 19 months ago

active record escaping - problems with numeric fields

Reported by: Tido Owned by:
Priority: minor Milestone: 1.0
Component: Version:
Keywords: database, active record Cc:

Description

many active record functions (if not all active record functions) don’t escape the fieldnames properly, which often produces sql errors when using numeric fieldnames, which have to be escaped (when iterating/computing its generally a good idea to use numeric field names, so this should be supported by codeigniter, too)

this bug applies to the query helper functions (http://codeigniter.com/user_guide/database/helpers.html), too and is somewhat connected with this bug http://codeigniter.com/bug_tracker/bug/1818/ but still no duplicate, as 1818 is more about “empty values” than escaping numeric fieldnames.

http://codeigniter.com/bug_tracker/bug/1819/

Change History

Changed 19 months ago by zombor

This also happens on MySQL fields that are reserved words like order.

Changed 19 months ago by zombor

  • status changed from new to closed
  • resolution set to fixed

Changed 19 months ago by zombor

Fixed in r44.

Note: See TracTickets for help on using tickets.