diff options
| author | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2010-03-22 19:05:27 +0000 |
|---|---|---|
| committer | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2010-03-22 19:05:27 +0000 |
| commit | 81605daff26e3a01b122761bc439e55f9a0de226 (patch) | |
| tree | 2c4257edb8fb1ea5a0de4a87bbacb045ed8b05d8 /contrib | |
| parent | d4c17c3546969138152bacc51b9691469be78a5d (diff) | |
Update query should be an UPDATE, not a SELECT.
git-svn-id: http://svn.digium.com/svn/asterisk/trunk@253758 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'contrib')
| -rwxr-xr-x | contrib/scripts/dbsep.cgi | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/contrib/scripts/dbsep.cgi b/contrib/scripts/dbsep.cgi index 0705aa671..d15390c23 100755 --- a/contrib/scripts/dbsep.cgi +++ b/contrib/scripts/dbsep.cgi @@ -99,7 +99,7 @@ if ($mode eq 'single') { } $get{$name}++; } - $sql = "SELECT " . join(",", cgi_to_where_clause($cgi, \%cfg, \%get)) . " FROM $table WHERE " . join(" AND ", @get); + $sql = "UPDATE $table SET " . join(",", cgi_to_where_clause($cgi, \%cfg, \%get)) . " WHERE " . join(" AND ", @get); $dbh = DBI->connect($cfg{dsn}, $cfg{dbuser}, $cfg{dbpass}); $affected = $dbh->do($sql); $dbh->disconnect(); |