[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