Re: getting max(id) using selectquery

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Sat Sep 20 2003 - 18:44:42 EDT

  • Next message: Bruce Buttles: "Modeler: Reengineer from SQL Server"

    On Friday, September 19, 2003, at 10:16 PM, G.Venu wrote:

    > hi all,
    >
    > could anyone give me syntax how to use the following sql statement
    > using "selectquery" and "expressionfactory"
    >
    > select max(id) from tbl_user;
    >
    > thanks

    Hi,

    In this case you would use a SqlSelectQuery. Follow this link for more
    info:

    http://objectstyle.org/cayenne/userguide/fetch/raw.html

    Andrus

    This archive was generated by hypermail 2.0.0 : Sat Sep 20 2003 - 18:39:12 EDT