From fb5128f9551c4fa7e50789d155a55d14f43fb979 Mon Sep 17 00:00:00 2001 From: tilghman Date: Mon, 22 Mar 2010 19:06:36 +0000 Subject: Merged revisions 253758 via svnmerge from https://origsvn.digium.com/svn/asterisk/trunk ........ r253758 | tilghman | 2010-03-22 14:05:27 -0500 (Mon, 22 Mar 2010) | 2 lines Update query should be an UPDATE, not a SELECT. ........ git-svn-id: http://svn.digium.com/svn/asterisk/branches/1.6.2@253760 f38db490-d61c-443f-a65b-d21fe96a405b --- contrib/scripts/dbsep.cgi | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'contrib') 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(); -- cgit v1.2.3