Re: column name twice error

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Mon Apr 14 2003 - 08:17:21 EDT

  • Next message: Scott Finnerty: "Re: column name twice error"

    John,

    Similar problem was reported here:

        
    http://sourceforge.net/tracker/
    index.php?func=detail&aid=709799&group_id=48132&atid=452068

    I could never reproduce this myself, but then insert statement
    generation has changed significantly since alpha 6. Does it also bomb
    when upgrading Cayenne to the latest nightly build?

    Andrus

    On Monday, April 7, 2003, at 11:00 AM, John Poole wrote:
    > v1.0a6
    > Cayenne is generating a statement which names the same column twice.
    > i.e. INSERT INTO aTable (id, userid, id) values (?, ?, ?) params[null,
    > 100, null];
    >
    > I have a table in mySQL that has an auto-generated primary key column,
    > which I need to use as a reference to another website. I've created an
    > object attribute for the "id" column, this seems to adding a second
    > "id"
    > to the insert statement. I've done this before with other tables, and I
    > can't see anything in the datamap that looks "wrong".
    >
    > Is there a "better" way to get a unique key for a row?
    >
    > John
    >
    >



    This archive was generated by hypermail 2.0.0 : Mon Apr 14 2003 - 08:22:26 EDT