--- chewbacca/PamOffLineSW/PacketUser.cpp	2008/12/18 14:46:56	1.4
+++ chewbacca/PamOffLineSW/PacketUser.cpp	2008/12/22 16:50:10	1.5
@@ -1,5 +1,5 @@
 //============================================================================
-// $Id: PacketUser.cpp,v 1.3 2008/12/18 12:58:37 mocchiut Exp $ 
+// $Id: PacketUser.cpp,v 1.4 2008/12/18 14:46:56 mocchiut Exp $ 
 // Description : 
 //============================================================================
 #include "PacketUser.h"
@@ -614,7 +614,7 @@
     << bad_pkt <<"','" << bad_pkt_read <<"','"<< bad_pkt_CalRead <<"','"<< num_PKT_Saved<<"','"
     << nome_input <<"',"
     <<"NULL,"<<_time_is_estimated<<   
-    ")";   	    
+    ");";   	    
 	string msg = oss.str();
 	mainLogUtil->logAll(msg);	
 	
@@ -664,7 +664,8 @@
     return;
    
   for (int i = 0; i<id_to_recover_index;i++){
-    oss << "UPDATE "<<  Table_ROOT_Good << " SET BOOT_NUMBER=" << boot_number << " WHERE ID_N=" << id_to_recover[i];  
+    oss.str("");
+    oss << "UPDATE "<<  Table_ROOT_Good << " SET BOOT_NUMBER=" << boot_number << " WHERE ID_N=" << id_to_recover[i] << ";";  
    query = oss.str();
    res= sqlServer->Query(query.c_str());
    if(!res)
@@ -676,12 +677,13 @@
    }
   }
 
-for (int i = 0; i<id_to_recover_index;i++){
-  oss << "UPDATE " <<  Table_ROOT_Merging << " SET BOOT_NUMBER=" <<  boot_number << " WHERE ROOT_ID_N=" << id_to_recover[i];  
-  query=oss.str();
-   res= sqlServer->Query(query.c_str());
-   if(!res)
-   {	
+  for (int i = 0; i<id_to_recover_index;i++){
+    oss.str("");
+    oss << "UPDATE " <<  Table_ROOT_Merging << " SET BOOT_NUMBER=" <<  boot_number << " WHERE ROOT_ID_N=" << id_to_recover[i] << ";";  
+    query=oss.str();
+    res= sqlServer->Query(query.c_str());
+    if(!res)
+      {	
 	   oss1<<"DBError UNABLE to: "<<query.c_str()<<endl;   
 	   msg1=oss1.str();
 	   mainLogUtil->logError(msg1);