AnsweredAssumed Answered

No Data

Question asked by bertmartin on Mar 31, 2011
Latest reply on Apr 1, 2011 by bertmartin
Another newbie question:

I have the following code:
   <sql:query var="initid">
   Select srm_resources.unique_name as uname from inv_ideas inner 
   join srm_resources on inv_ideas.initiator_id = srm_resources.user_id 
   where inv_ideas.id = ?

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

  <core:set var="email_add" value="${initid.rows(0).uname}@company.com" /> 
When I run the query directly I get the initiator ID as expected. However, in the script I don't get a value back.

Is this the right syntax?
 ${initid.rows(0).uname}
Thanks in advance.

Outcomes