comment on

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 );   
    }
[download]

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

In reply to Accept array from Form and put in DB by 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.


Keep It Simple, Stupid
	PerlMonks