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
