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;-)
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
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
Post a Comment