Guest User

Untitled

a guest
Dec 14th, 2017
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. <p>As a member of these organizations:</p>
  2. %%[
  3. var @rows, @row, @rowCount, @numRowsToReturn, @lookupValue, @i
  4.  
  5. set @lookupValue = AttributeValue("Contact_Key") /* value from attribute or DE column in send context */
  6.  
  7. set @numRowsToReturn = 0 /* 0 means all, max 2000 */
  8. set @rows = LookupOrderedRows("ENT.User_Organization",@numRowsToReturn,"Organization_Id","Contact_key", @lookupValue)
  9. set @rowCount = rowcount(@rows)]%%
  10.  
  11. %%[if @rowCount > 0 then
  12.  
  13. for @i = 1 to @rowCount do
  14.  
  15. var @orgid, @DEColumn2`
  16. set @row = row(@rows,@i) /* get row based on counter */
  17. set @orgid = field(@row,"Organization_Id")
  18. SET @orgname = LookUp('ENT.Organizations', 'Name', 'Id', @orgid)
  19.  
  20. ]%%
  21. <ul style="margin-left:30px;">
  22. <li> %%=v(@orgname)=%%</li>
  23. </ul>
  24. %%[
  25. next @i ]%%
  26.  
  27. %%[ else ]%%
  28.  
  29. our sports community
  30.  
  31. %%[ endif ]%%
Add Comment
Please, Sign In to add comment