camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Claus Ibsen <claus.ib...@gmail.com>
Subject Re: camel-velocity: empty variable
Date Fri, 03 Apr 2009 09:54:30 GMT
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
<matteo.redaelli@libero.it> 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

Mime
View raw message