Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- %%[
- var @rows, @row, @rowCount, @numRowsToReturn, @lookupValue, @i
- set @lookupValue = "whee"
- set @numRowsToReturn = 0 /* 0 means all */
- set @rows = LookupOrderedRows("DataExtensionName",@numRowsToReturn,"DEColumn1 desc, DEColumn2 asc","LookupColumn", @lookupValue)
- set @rowCount = rowcount(@rows)
- if @rowCount > 0 then
- for @i = 1 to @rowCount do
- var @DEColumn1, @DEColumn2
- set @row = row(@rows,@i) /*get row based on loop counter */
- set @DEColumn1 = field(@row,"DEColumn1")
- set @DEColumn2 = field(@row,"DEColumn2")
- ]%%
- Row %%=v(@i)=%%, DEColumn1 is %%=v(@DEColumn1)=%%, DEColumn2 is %%=v(@DEColumn2)=%%
- %%[
- next @i ]%%
- %%[ else ]%%
- No rows found
- %%[ endif ]%%
Add Comment
Please, Sign In to add comment