Forum OpenACS Development: using results from db_multirow

Collapse
1: using results from db_multirow
Posted by Matthew Taylor on 09/18/04 10:08 AM
I want to be able to iterate through the results of db_multirow:

db_multirow core_units core_units_sql { }

I want to put all the values from "core_units" into a string that will look like this "start -> unit1 -> unit2 ->... -> unitn -> end;" I tried the following code:

set data "digraph elec { start"
while "x < $core_units:rowcount"
{
    set data "$data  -> $core_units:uos_code"
    set x [expr $x + 1]
}
set data "$data end; }"

however I seem to get an error saying :

can't read "core_units": no such variable
    while executing
"while "x < $core_units:rowcount"

Collapse
2: Re: using results from db_multirow (response to 1)
Posted by Claudio Pasolini on 09/18/04 03:17 PM
set data "digraph elec { start"
db_multirow core_units core_units_sql { } {
append data " -> $uos_code"
}
set data "$data end; }"