Re: How to do these two tasks properly in cayenne?

From: Gili (cowwo..bs.darktech.org)
Date: Tue Sep 20 2005 - 10:56:11 EDT

  • Next message: Gentry, Michael \(Contractor\): "RE: How to do these two tasks properly in cayenne?"

            Sorry, I meant to say "invoke size() on the resulting resulting List".

    Gili

    Gili wrote:
    >
    > For #1, I believe it is possible to create a SelectQuery for the
    > table in question, and invoke size() on the resulting size(). My guess
    > is that Cayenne will be smart enough to invoke "select count(*)" without
    > actually retrieving the actual rows.
    >
    > Gili
    >
    > Tore Halset wrote:
    >
    >> On Sep 20, 2005, at 9:26, Tomas Jucius wrote:
    >>
    >>> I wanted to know how properly to do these:
    >>>
    >>> 1) count rows in the table
    >>> 2) execute "password" function and get result..
    >>>
    >>> DataBase: MySql..
    >>>
    >>> Is it possible with cayenne to execute simple query and get result map?
    >>
    >>
    >>
    >> Yes, using SQLTemplate
    >>
    >> http://www.objectstyle.org/cayenne/userguide/fetch/sqltemplate.html
    >>
    >> - Tore.
    >>
    > 

    -- 
http://www.desktopbeautifier.com/

    This archive was generated by hypermail 2.0.0 : Tue Sep 20 2005 - 10:56:12 EDT