Spalte "ordnumber" oder "quonumber" muss eindeutig sein.

diff --git a/SL/OE.pm b/SL/OE.pm
index d302311602c8e0380dd0790cbb6226c630d2c381..32ba235d9f93cd6088fd99914f3fa9e87ed26ab2 100644 (file)
--- a/SL/OE.pm
+++ b/SL/OE.pm
@@ -120,7 +120,7 @@ sub transactions {
   }
 
   if ($form->{$ordnumber}) {
   }
 
   if ($form->{$ordnumber}) {

-    $query .= qq| AND $ordnumber ILIKE ?|;
+    $query .= qq| AND o.$ordnumber ILIKE ?|;

     push(@values, '%' . $form->{$ordnumber} . '%');
   }
 
     push(@values, '%' . $form->{$ordnumber} . '%');
   }