Re: Velocity parsing error with "##"

2010-08-13 Thread Laurent Marchal
I use this way and it worked like a charm. Thank you ! Laurent. Le 08/13/2010 04:12 AM, Evgeny Ryabitskiy a écrit : I suggest you could use #bind directive here. SELECT COUNT(JOBNAME) AS RESULT FROM JMASTER WHERE SKDID = 67 AND UPPER(JOBNAME) = #bind($JOB_PARAM) So if you pass TEST## in JOB_

Re: Velocity parsing error with "##"

2010-08-13 Thread Evgeny Ryabitskiy
I suggest you could use #bind directive here. SELECT COUNT(JOBNAME) AS RESULT FROM JMASTER WHERE SKDID = 67 AND UPPER(JOBNAME) = #bind($JOB_PARAM) So if you pass TEST## in JOB_PARAM it will be handled via JDBC as String (not by Velocity), so it will be prepared statement. Also it will protect yo

Velocity parsing error with "##"

2010-08-13 Thread Laurent Marchal
Hi all, After months of using Cayenne 3.0 (which is awesome BTW) I just discovered that when I put two "##" in some of my object names in database and then I use some SQLTemplate I have a Velocity error. It seems that Velocity does not like ## because it's detected as a bad directive. I