Re^4: How to retain a value passed from another link to a script

Many thanks Poj, You are the only ONE :) OK you are right the update is failing I changed the code though :

if ( ($action eq "UPDATE") && ($orderid =~ /\d+/)) {
my @data=();
  my @fields = qw!unitprice quantity discount !; 
  for my $f (@fields){
    push @data,$q->param($f) || '' ;
  }
  push @data,$orderid;

  my $sql = qq! UPDATE
                   "Order_Details"
                SET
                   "UnitPrice" = ?,
                   "Quantity"  = ?,
                   "Discount"  = ?
                WHERE "OrderID" = ? !;

  my $count = $dbh->do( $sql,undef,$orderid );
  $msg = "$count Record updated - $sql, $orderid";
[download]

Please help !!!

Comment on Re^4: How to retain a value passed from another link to a script Download Code

Replies are listed 'Best First'.
Re^5: How to retain a value passed from another link to a script by poj (Abbot) on Jul 11, 2014 at 19:48 UTC
`my $count = $dbh->do( $sql,undef,@data ); # not $orderid` [download] poj	[reply] [d/l]