Re: Query Problem

From: Jerome Chan (eviltof..ac.com)
Date: Mon Sep 19 2005 - 23:14:20 EDT

  • Next message: Gili: "DataContext.localObjects() for modified objects"

    Just to add in more data. The FIRST row always returns correctly. The
    second row onwards always have null values in BOOLEAN attributes. I'm
    using mysql and storing the boolean attributes as VARCHAR of length
    5. Is this how you store BOOLEAN attributes?

    On 19 Sep 2005, at 4:54 PM, Jerome Chan wrote:

    > I have three tables.
    >
    > User
    > Boolean enabled
    > int id
    > String name
    > ... more data
    >
    > Group
    > String name
    > int id
    > ... more data
    >
    > UserToGroupMappingDBEntity
    > int id
    > int groupid
    > int userid
    >
    > The user is mapped to the groups table via the intermediate
    > UserToGroupMappingDBEntity. I create several groups and populate
    > them with users and call DataContext.commitChanges. When I call
    > Group.getUsers for a particular group, I get a list object with the
    > correct number of Users but some of the data in the Users in the
    > list are not fetched; they have a null value. If I perform a
    > DataContext.refetchObject, the values are not null.
    >
    > Any clues on how to work around this thing without refetching the
    > object?
    >
    >
    >
    >



    This archive was generated by hypermail 2.0.0 : Mon Sep 19 2005 - 23:14:32 EDT