AnsweredAssumed Answered

Concatenating fields

Question asked by bertmartin on Mar 31, 2011
Latest reply on Mar 31, 2011 by mark
Very new to gel scripting so trying to figure some things out. I am attempting to concatenate a field with a string and I am getting an error:

My Code---
<gel:script xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
    xmlns:core="jelly:core"
    xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
    xmlns:sql="jelly:sql" xmlns:xsd="http://www.w3.org/2001/XMLSchema"        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<gel:setDataSource dbId="niku"/>

   <sql:query var="init_id">
   Select srm_resources.unique_name from inv_ideas inner 
   join srm_resources on inv_ideas.initiator_id = srm_resources.user_id 
   where inv_ideas.id = ?

   <sql:param value="${gel_processInstanceId}"/>
   </sql:query>

  <gel:set var="email_add" value="${init_id.rows(0).unique_name}@companyname.com" /> 

  <gel:email from="#PMO@companyname.com"
    fromName="Clarity Admin"
    to=${email_add}
    subject="Notification">
    This is an automatic message.  Do not respond. 
  </gel:email>

</gel:script>
This is the error I am getting:

In gel:set, 'var' and 'value' cannot both be set

Outcomes