Forum OpenACS Development: Re: accessing db_multirow variable in tcl

Collapse
Posted by russ m on
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.