Hi Andrew, thanks for that. I see what the problem is. But if I can’t use EJBQL when generating queries that use dates, can I go down any different paths or do I have to revert to writing plain old SQL?
Cheers, - hugi > On 12. ágú. 2015, at 05:36, Andrew Lindesay <a...@lindesay.co.nz> wrote: > > Hi Hugi; > > I think this was me; see CAY-1932 for some details on what I did there. > > cheers. > > On 12/08/15 10:09, Hugi Thordarson wrote: >> Hi all. >> >> I have a utility method that selects a row count given a DataObject class >> and an Expression, as seen here: >> >> https://gist.github.com/hugith/d2cdaf60a6ee12aa0d17 >> <https://gist.github.com/hugith/d2cdaf60a6ee12aa0d17> >> >> I was using this today when I suddenly got the error message "the scalar >> type 'Date' is not supported as a scalar type in EJBQL”. Turns out that if I >> use a date in an Expression, it can’t be converted to EJBQL. >> >> Can anyone suggest a workaround? Also, should I be creating utility methods >> like this in a different way than by using EJBQL? I have quite a few utility >> methods that all construct queries using EJBQL, but they become rather >> useless if I can’t use dates in them. >> >> Cheers and thanks, >> - hugi >> > > > -- > Andrew Lindesay