java - Filter on current date within Castor OQL -


i'm running java cocoon 2 , castor oql. i'm trying filter oql query today's date, can't seem figure out (or find in google) syntax of date. database mysql, oql mapped java classes... doing search on field_date >= now() doesn't work. ideas? can't stand limitations of site, it's have work with.

it's been while since used cocoon, can't have great answer you. since question has been stagnating, couple of points suggest;-)

  1. syntax should matter if coding literal sql string. under impression castor can bind variables (and let oql select appropriate format). i.e. " field_date >= ?", mydateval

  2. the castortransformer seemed make brief appearance in 1 specific version of cocoon, , afaik not in latest. if have control on cocoon version running, might want @ upgrading , alternatives castortransformer


Comments

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

asp.net - In javascript how to find the height and width -

c# - DataTable to EnumerableRowCollection -