Matthew,
You can also iterate over a multirow after it has been created - check the documentation for template::multirow
For example,
db_multirow assets assets {
select asset_id,
from ...
}
...
set asset_id_l [list]
multirow foreach assets {
lappend asset_id_l $asset_id
}
Technically it's equivalent to using a code block on the end of your db_multirow.