Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Compare time using EJB QL?  RSS feed

Valerie Pooh
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I have been trying to display results that is not based within the specified time range. Anyone know how to compare time? It works fine if i am trying to find a particular time, but does not work if i compare within a range. The temporal type i used is Time and direction is bi-directional. For example:

Funny thing i observed was even thought i used left join, i still wasn't able to get all the Venues in the Venue entity even though some of them are not mapped to any event in the Event entity. Any suggestion is appreciated, thanks.
[ September 07, 2008: Message edited by: Valerie Pooh ]
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!