Re: Using an Escaped LIKE Clause

2010-01-28 Thread Andrus Adamchik
Hi Andrew, By straightforward I meant from a general framework architecture standpoint, i.e. no changes to the processing pipeline, just extending what we have. Yes, a minimal implementation would be adding escape char to PatternMatchNode and then tweak the QualifierTranslator to actually

Re: Using an Escaped LIKE Clause

2010-01-28 Thread Andrew Lindesay
Hi Andrus; Thanks for that -- I am fairly new to actually using Cayenne. Are you able to give me any pointers? As a guess I think I would need to add the escape character to "PatternMatchNode" and then modify something around "DataObjectMatchTranslator" or "QualifierTranslator" to turn that i

Re: Using an Escaped LIKE Clause

2010-01-28 Thread Andrus Adamchik
Lachlan is correct. Escaping is only supported in EJBQL now: SELECT p FROM Painting p WHERE p.paintingTitle LIKE 'X_' ESCAPE 'X' Should be more or less straightforward to add it to Expressions I guess. Andrus On Jan 28, 2010, at 4:06 AM, Lachlan Deck wrote: Hi Andrew, On 28/01/2010

Re: Using an Escaped LIKE Clause

2010-01-27 Thread Lachlan Deck
Hi Andrew, On 28/01/2010, at 12:41 PM, Andrew Lindesay wrote: > Hello; > > A question about escaping a LIKE qualifier; > > ExpressionFactory.likeExp(...,...) > > JDBC specifies the ability to use '%' and '_' as matchers for characters and > a character respectively. It is then possible

Using an Escaped LIKE Clause

2010-01-27 Thread Andrew Lindesay
Hello; A question about escaping a LIKE qualifier; ExpressionFactory.likeExp(...,...) JDBC specifies the ability to use '%' and '_' as matchers for characters and a character respectively. It is then possible to escape use of those characters as in the following example; SELE