Happy Holidays!
I think $slurping too much wine this weekend has dulled my abilities once again.
I'm trying to accept an array (actually multiple arrays but I'm trying to simplify the process first so I can understand it) from a form, properly quote each value and place it into a DB. Here's my feeble attempt:
my @quantity = param('quantity');
my $item_number = param("item_number");
#my @item_number = param("item_number");Not used until I understand ho
+w to pass one array in first.
my $quantity = $dbh->quote( $quantity );
my $item_number = $dbh->quote( $item_number );
foreach $quantity (@quantity ) {
my $sql = qq/
INSERT INTO needed_details (quantity, item_number) VALUES ($quanti
+ty, $item_number)
/;
my $rv = $dbh->do( $sql );
}
When I put two values into the array (e.g. @quantity = 2,1), I get four entries into the DB. Two duplicates entries. Please help me understand my mistake. TIA
peppiv
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|