help - mysql date search

From: Frank (farocc..otmail.com)
Date: Wed Mar 07 2007 - 11:06:31 EST

  • Next message: Mike Kienenberger: "Re: Help: getting NPE at ObjectStoreGraphDiff.preprocess"

    Hello,

    I cannot get cayenne to l imit records based on a mysql date field.
    I tried two variations below.
    The date is stored as datetime and has a date & time value.
    I only need to limit records based on date.
    What am I doing wrong?
    //Expression qualifier = ExpressionFactory.matchDbExp(Bedlog.ADMIT_REQUEST_DATE_PROPERTY, requestDate);

    Expression qualifier = ExpressionFactory.betweenExp(Bedlog.ADMIT_REQUEST_DATE_PROPERTY, requestDate,requestDate);

    query.andQualifier(qualifier);

    Regards,

    Frank

    This archive was generated by hypermail 2.0.0 : Wed Mar 07 2007 - 11:07:01 EST