One of the columns returned from your fetch is null. Use database function to convert null values to something else (i.e. NLV() in Oracle).
----------------- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: xaver biton [mailto:[EMAIL PROTECTED] Sent: Thursday, September 09, 2004 12:57 PM To: [EMAIL PROTECTED] Subject: Update query :: Use of uninitialized value in concatenation 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 This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
