Hi
Its Velocity that just renders it by default if the variable is not there
http://velocity.apache.org/engine/releases/velocity-1.6.2/user-guide.html#variables
You can use ! after the $ then it reneders a space instead
$!{in.body.cid) but if you want it to render null, then you probably
have to do some #if #else #end in VLT templating
On Fri, Apr 3, 2009 at 10:45 AM, Matteo Redaelli
<[email protected]> wrote:
>
> 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.
>
>
--
Claus Ibsen
Apache Camel Committer
Open Source Integration: http://fusesource.com
Blog: http://davsclaus.blogspot.com/
Twitter: http://twitter.com/davsclaus
Apache Camel Reference Card:
http://refcardz.dzone.com/refcardz/enterprise-integration
