[ic] Array

Dan Browning interchange-users@icdevgroup.org
Mon Jun 24 15:09:00 2002


At 10:14 AM 6/19/2002 +0200, you wrote:
>Hello,
>
>can anybody help me:
>
>How can I declare an array from the result of a query in Interchange?
>
>Zoli

See:

http://interchange.redhat.com/cgi-bin/ic/docfly.html?mv_arg=ictags04.55

Examples:

    my $sql = "select * from products order by price";
    my $result_array = $Tag->query( { sql => $sql,  },
                                    $body );
    my ($same_results, $col_name_hash, $col_name_array) =
                       $Tag->query( { sql => $sql,  },
                                    $body );

    my $result_hasharray = $Tag->query( { sql     => $sql,
                                          hashref => 'my_results',  },
                                        $body );

HTH, HAND,

+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Dan Browning, Kavod Technologies <db@kavod.com>
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Power corrupts.  Absolute power is kind of neat"
                 -- John Lehman, Secretary of the Navy 1981-1987