aboutsummaryrefslogtreecommitdiffstats
path: root/res/res_config_odbc.c
diff options
context:
space:
mode:
authoranthm <anthm@f38db490-d61c-443f-a65b-d21fe96a405b>2004-08-23 19:07:15 +0000
committeranthm <anthm@f38db490-d61c-443f-a65b-d21fe96a405b>2004-08-23 19:07:15 +0000
commit39e8e1aeab5d3092cb665324685f8a0e03cdc2a2 (patch)
treee5db319af65433ed73707d122c3221b043873737 /res/res_config_odbc.c
parentbc009cd7a3a20d44d5fbed8b4cd2ba4c227a7b9a (diff)
make bug 2272 (which is actually caused by human error) less likely to happen
git-svn-id: http://svn.digium.com/svn/asterisk/trunk@3637 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'res/res_config_odbc.c')
-rwxr-xr-xres/res_config_odbc.c2
1 files changed, 1 insertions, 1 deletions
diff --git a/res/res_config_odbc.c b/res/res_config_odbc.c
index 1d5cb8d51..3f8490530 100755
--- a/res/res_config_odbc.c
+++ b/res/res_config_odbc.c
@@ -96,7 +96,7 @@ static struct ast_config *config_odbc (char *file, struct ast_config *new_config
SQLBindCol (stmt, 7, SQL_C_CHAR, &var_name, sizeof (var_name), &err);
SQLBindCol (stmt, 8, SQL_C_CHAR, &var_val, sizeof (var_val), &err);
- snprintf(sql, sizeof(sql), "select * from %s where filename='%s' and commented=0 order by filename,cat_metric desc,var_metric asc,id", table, file);
+ snprintf(sql, sizeof(sql), "select * 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);
res = SQLExecDirect (stmt, sql, SQL_NTS);
if ((res != SQL_SUCCESS) && (res != SQL_SUCCESS_WITH_INFO)) {