2 Replies Latest reply on Apr 29, 2003 1:11 AM by Adrian Richter

    Problems w/ EJB QL and java.sql.Timestamp

    David Durst Newbie

      I am currently experiencing a issue where I am receiving nothing back from a ejb-ql query. Logically I believe it should accomplish the following:

      Return to me all Journal Lines attached to a specific account between
      a start and end time.

      Here is the query itself:

      <![CDATA[SELECT OBJECT(line) From JournalLineEJB AS line WHERE line.account.accountID = ?1 AND
      line.journalEntry.journalEntryTimeStamp > ?2 AND
      line.journalEntry.journalEntryTimeStamp < ?3]]>

      Can anyone see why this query might be giving me an issue?