diff options
| author | Tilghman Lesher <tilghman@meg.abyt.es> | 2010-03-22 19:05:27 +0000 |
|---|---|---|
| committer | Tilghman Lesher <tilghman@meg.abyt.es> | 2010-03-22 19:05:27 +0000 |
| commit | fdef7e5deb55028d4361814dac02b95568f1fae3 (patch) | |
| tree | 2c4257edb8fb1ea5a0de4a87bbacb045ed8b05d8 | |
| parent | 957dfc8c6d7c607c6b803ea1b5220c388eff8edb (diff) | |
Update query should be an UPDATE, not a SELECT.
git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@253758 65c4cc65-6c06-0410-ace0-fbb531ad65f3
| -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(); |