<?xml version="1.0" encoding="windows-1252"?>
<node id="640273" title="Re^2: DBD::Oracle 's DBI binding of arrays" created="2007-09-21 02:40:16" updated="2007-09-20 22:40:16">
<type id="11">
note</type>
<author id="5348">
Corion</author>
<data>
<field name="doctext">
&lt;p&gt;[doc://map] takes a list and returns a new list. The new list is created by gathering the results of the codeblock. The codeblock is invoked one per item in the original list:&lt;/p&gt;
&lt;c&gt;
use strict;
use Data::Dumper;
my @items = qw(1 2 3 4 5 6 7);
my @new_items;

# Make a copy of @items in a very inefficient way
@new_items = map { $_ } @items;

# Make a new list 2 3 4 5 6 7 8
@new_items = map { $_+1 } @items;

# Make a new list of strings:
@new_items = map { "&gt;$_&lt;" } @items;

# Make a new list with all items appearing twice:
# 1 1 2 2 3 3 4 4 5 5 6 6 7 7
@new_items = map { $_ =&gt; $_ } @items;

# Make a new list with all items quoted:
map { $dbh-&gt;quote($_) } @userArray
&lt;/c&gt;</field>
<field name="root_node">
640255</field>
<field name="parent_node">
640271</field>
</data>
</node>
