Mapping SQL query results to a Entity Object

From: John Martyniak (jmarty..x.netcom.com)
Date: Wed Mar 02 2005 - 17:38:31 EST

  • Next message: Gentry, Michael \(Contractor\): "RE: Mapping SQL query results to a Entity Object"

    I would like to find out if it is possible to map the results of a query to
    an entity object that doesn't map to a db table.

    For example:

    I have a query something like:
    Select username, count(*) counts from users group by username order by
    counts desc limit 5;

    I would like this to show up in a object that I can then use.

    Is this even possible?

    Or does a obj entity have to map to a db entity? If you go through modeler
    it certainly seems like it needs to.

    Any thoughts or suggestions would be very helpful.

    -john

    This archive was generated by hypermail 2.0.0 : Wed Mar 02 2005 - 17:38:36 EST