ciao
I use velocity to build a sql statement.
"
update mdl_user set
idnumber='${in.body.cid}',icq='${in.body.usertype}'
where
upper(username)=upper('${in.body.userid}')
"
it works fine if ${in.body.cid} and ${in.body.usertype} are not null
if one of them is null (for example ${in.body.cid}), after the execution of
the sql statement, the database field idnumber is not null (this is my wish)
but contains the string '${in.body.cid}'
what wrong? how could I solve it?
MY route is
<route>
<from uri="activemq:topic:user.update.response" />
<to uri="velocity:sql-moodle-user-update.vm" />
<to uri="jdbc:moodleDB" />
</route>
Thanks in advance
Matteo
--
View this message in context:
http://www.nabble.com/camel-velocity%3A-empty-variable-tp22864380p22864380.html
Sent from the Camel - Users mailing list archive at Nabble.com.
