Cheer Andrus,

I did as you suggested and gave the Expression.fromString() a try and this worked.

I'm not onto v3 yet so I can't use EJBQLQuery.

Dave

Andrus Adamchik wrote:
"number1<=number2" means comparing two columns? ExpressionFactory won't support it... IIRC even Expression.fromString() will not support comparing two columns, instead expecting path vs value comparison (worth a try though).

EJBQLQuery on the other hand will support such comparison.

Andrus

On Jan 8, 2009, at 6:19 PM, Dave Merrin wrote:

Hi,

I'm trying to create an expression that compares to fields in a single table i.e. number1<=number2. I'm using the ExpressionFactory to create all my expressions. Can I still use it to do create this expression?

Cheers,

Dave




Reply via email to