diff options
| -rwxr-xr-x | FS/bin/freeside-cdr-asterisk_sql | 8 |
1 files changed, 4 insertions, 4 deletions
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"; |