Forum OpenACS Development: Response to "faking" columns in an ACS4 db_multirow

Here is how I like to do it:
set sql "select first_names, last_name from users"

set extra_eval "set row(whole_name)  "$row(first_names) 
$row(last_names)" "

template::query users multirow $sql -db  $db  -eval $extra_eval
This should do exactly what you want, and make a @users.whole_name@ available in the .adp