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 = ?

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

  <core:set var="email_add" value="${initid.rows(0).uname}" /> 
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?
Thanks in advance.