Forum OpenACS Development: Re: accessing db_multirow variable in tcl

you can iterate with each row returned by the query:
db_multirow -extend { user_url } users users_query {
    select user_id first_names, last_name, email from cc_users
} {
    set user_url [acs_community_member_url -user_id $user_id]
}