Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: DBI SQL statement in while loop

by UnderMine (Friar)
on Dec 03, 2002 at 21:42 UTC ( [id://217358]=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
      my $sql2 = qq/
         INSERT INTO transaction_details (quantity, gross_sales) 
          VALUES ($quantity,  convert (money, $gross_sales))
         /;
    
  2. or download this
      my $sql2 = qq/
         INSERT INTO transaction_details (quantity, gross_sales) 
    ...
         my $gross_sales = $cgi->param("gross_sales_$1");
         my $rv = $sth->execute( $quantity, $gross_sales );
       }
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://217358]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others avoiding work at the Monastery: (4)
As of 2024-04-18 19:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found