diff options
author | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2009-08-20 15:29:53 +0000 |
---|---|---|
committer | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2009-08-20 15:29:53 +0000 |
commit | d75aa61b738e5b2a2c7983c8461fed56e3accd4d (patch) | |
tree | 148766befd615e1ff2452fc921a5ba5ec8228822 /addons | |
parent | 5ffb96a5560b109a6af97036ab23a56e6a45c430 (diff) |
Select uncommented lines, not commented ones.
(closes issue #15746)
Reported by: makoto
git-svn-id: http://svn.digium.com/svn/asterisk/trunk@213248 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'addons')
-rw-r--r-- | addons/res_config_mysql.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/addons/res_config_mysql.c b/addons/res_config_mysql.c index dae856ea4..273114cbe 100644 --- a/addons/res_config_mysql.c +++ b/addons/res_config_mysql.c @@ -927,7 +927,7 @@ static struct ast_config *config_mysql(const char *database, const char *table, return NULL; } - ast_str_set(&sql, 0, "SELECT category, var_name, var_val, cat_metric FROM %s WHERE filename='%s' and commented=1 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id", table, file); + ast_str_set(&sql, 0, "SELECT category, var_name, var_val, cat_metric FROM %s WHERE filename='%s' and commented=0 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id", table, file); ast_debug(1, "MySQL RealTime: Static SQL: %s\n", ast_str_buffer(sql)); |