Hi, I'recieving the following errors, ans I don't know why.


proe-balance.pl line 418.
Use of uninitialized value in concatenation (.) or string at proe-balance.pl line 418. /* this line appear more times*/
DBD::mysql::db do failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' `description`=, `as_soon_as`=,
`wish_deliver`=, `order_date at proe-balance.pl line 428.
DBD::mysql::db do failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' `description`=, `as_soon_as`=,
`wish_deliver`=, `order_date at proe-balance.pl line 428.
Error while running process: java.io.IOException: The pipe has been ended
Process perl exited with code 2


This is my code:
################################################################
while (my @orders_local = $sth_orders_local->fetchrow_array){
 my $orders_id                  = $orders_local[0];
 my $interne_customer_id        = $orders_local[1];
 my $vo_nr                      = $orders_local[2];
 my $tel_consult                = $orders_local[3];
 my $sub_vo_nr                  = $orders_local[4];
 my $description                = $orders_local[5];
 my $as_soon_as                 = $orders_local[6];
 my $wish_deliver_cr            = $orders_local[7];
 my $order_date                 = $orders_local[8];
 my $activation_date            = $orders_local[9];
 my $state                      = $orders_local[10];
 my $name_order                 = $orders_local[11];
 my $forename_order             = $orders_local[12];
 my $address_order              = $orders_local[13];
 my $streetnumber_order         = $orders_local[14];
 my $zip_order                  = $orders_local[15];
 my $city_order                 = $orders_local[16];
 my $adaptor                    = $orders_local[17];
 my $evn                        = $orders_local[18];
 my $online                     = $orders_local[19];
 my $debit_mandate              = $orders_local[20];
 my $from_company               = $orders_local[21];
 my $mail                       = $orders_local[22];
 my $mail_invoices              = $orders_local[23];
 my $print_invoices             = $orders_local[24];
 my $web_invoices               = $orders_local[25];

 my $sql = <<EOT;
 UPDATE `orders` SET `interne_customer_id`=$interne_customer_id,
 `tel_consult`=$tel_consult,
`sub_vo_nr`=$sub_vo_nr,
`description`=$description,
`as_soon_as`=$as_soon_as,
`wish_deliver`=$wish_deliver_cr,
`order_date`=$order_date,
`activation_date`=$activation_date,
`state`=$state,
`name_order`=$name_order,
`forename_order`=$forename_order,
`address_order`=$address_order, `streetnumber_order`=$streetnumber_order,
`zip_order`=$zip_order,
`city_order`=$city_order,
`adaptor`=$adaptor,`evn`=$evn,
`online`=$online,
`debit_mandate`=$debit_mandate,
`from_company`=$from_company,
`mail`=$mail,
`mail_invoices`=$mail_invoices,
`print_invoices`=$print_invoices,
`web_invoices`=$web_invoices

WHERE vo_nr = $vo_nr AND orders_id = $orders_id

EOT

$dbh->do($sql);

}
############################################################

thks.

Xaver Biton

Reply via email to