Query Examples Needed – Expression.fromString() syntax?

From: Eric Lazarus (ericllazaru..ahoo.com)
Date: Wed May 24 2006 - 12:51:40 EDT

  • Next message: Gentry, Michael \(Contractor\): "RE: Query Examples Needed Expression.fromString() syntax?"

    Would anyone reply with some nice examples of
    SelectQuery beside the simple one here:

    http://www.objectstyle.org/cayenne/userguide/dataobjects/dataobjects-example.html

    Expression e =
      ExpressionFactory.greaterExp("estimatedPrice",
                            new BigDecimal(100000.0))

    I need to do things with ANDS and ORs and I’m not sure
    how to use expression factory (or should I use
    Expression.fromString() ?) to do it.

    Right now my immediate need is to be able to construct
    a query with an arbitary number of possible "and"
    clauses depending on what the user types.

    Seems like fromString() is going to be easy and
    powerful but I can’t find an example of the syntax
    using google.

    Even just a few nice examples would be helpful.

    Can I look at the attributes of sub objects using this
    syntax? How?

    Thanks!

    Eric

    __________________________________________________
    Do You Yahoo!?
    Tired of spam? Yahoo! Mail has the best spam protection around
    http://mail.yahoo.com

    This archive was generated by hypermail 2.0.0 : Wed May 24 2006 - 12:52:42 EDT