X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2Fbin%2Ffreeside-cdr-asterisk_sql;h=529ec9bb977d69bde290086df7a22ec06ef6e1f9;hb=11bbf29de447fe39e9d7155fe280a0df70fa8c3c;hp=6e63ff00866d595f9e0e60be9e946f66ea8a51c3;hpb=b285918ec3ab6c8203e9f8feaf234da306456e5e;p=freeside.git

diff --git a/FS/bin/freeside-cdr-asterisk_sql b/FS/bin/freeside-cdr-asterisk_sql
index 6e63ff008..529ec9bb9 100755
--- a/FS/bin/freeside-cdr-asterisk_sql
+++ b/FS/bin/freeside-cdr-asterisk_sql
@@ -104,17 +104,17 @@ while ( my $row = $sth->fetchrow_hashref ) {
 
     $imports++;
 
-    my $where = '';
+    my $usql = "UPDATE $table SET freesidestatus = 'done' WHERE ";
     my @args = ();
     if ( $opt{V} >= 12 ) {
-      $where = 'id = '. $row->{'id'};
+      $usql .= ' id = '. $row->{'id'};
       @args = ( undef );
     } else {
-      $where = 'calldate = ? AND src = ? AND dst = ?';
+      $usql .= ' calldate = ? AND src = ? AND dst = ?';
       @args = ( undef, $row->{'calldate'}, $row->{'src'}, $row->{'dst'}, );
     }
 
-    if ( $dbi->do("UPDATE $table SET freesidestatus = 'done' $where", @args) ) {
+    if ( $dbi->do($usql, @args) ) {
       $updates++;
     } else {
       warn "failed to set status: ".$dbi->errstr."\n";