Yeah, expression parser can't cope with special chars. But you can
always assemble the expression by hand:
Expression e = ExpressionFactory.matchDbExp
(Bsypemp.EMHSPPOUND_PK_COLUMN, new Integer(1));
e = e.andExp(ExpressionFactory.likeExp(Bsypemp.EMYLNM_PROPERTY, lname
+"%"));
Andrus
On Feb 14, 2007, at 10:02 AM, Frank wrote:
Why do I get this error?
Lexical error at line 1, column 6. Encountered: "#" (35), after : ""
Expression expression = Expression.fromString
(Bsypemp.EMHSPPOUND_PK_COLUMN +" = 1 and EMYLNM LIKE $lastName");
Map parameters = new HashMap(1);
parameters.put("lastName", lname+"%");
SelectQuery query = new SelectQuery
(Bsypemp.class,expression.expWithParameters(parameters));
