Re: [JIRA] Commented: (CAY-878) Field names for INSERT are unquoted

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Oct 11 2007 - 11:42:14 EDT

  • Next message: Aristedes Maniatis: "Re: [VOTE] Cayenne releases 1.2.4 and 2.0.4"

    On Oct 11, 2007, at 6:31 PM, Scott Anderson wrote:

    > Looks like CAY-289 wants strings escaped with square brackets. The
    > standard, for MySQL at least, is backquotes.

    Yeah, the quote char differs between the DB's.

    > I worked around this problem by renaming the field in the database
    > from
    > `group` to `groupId`

    Sure. Actually this is not a very common problem as most people would
    avoid using DB reserved keywords as column names, but we should still
    fix it in Cayenne for those few who do.

    Andrus

    This archive was generated by hypermail 2.0.0 : Thu Oct 11 2007 - 11:42:45 EDT