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_
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
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