From 65fc87b2458e61a9718aaf55ecffb5d24caebc6a Mon Sep 17 00:00:00 2001 From: Mark Spencer Date: Thu, 8 Jul 2004 13:18:04 +0000 Subject: Merge bkw_'s ODBC patch git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@3395 65c4cc65-6c06-0410-ace0-fbb531ad65f3 --- res/res_config_odbc.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'res/res_config_odbc.c') diff --git a/res/res_config_odbc.c b/res/res_config_odbc.c index dead1233b..c836dbdcd 100755 --- a/res/res_config_odbc.c +++ b/res/res_config_odbc.c @@ -111,7 +111,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); - sprintf(sql,"select * from %s where filename='%s' and commented=0 order by filename,cat_metric,var_metric,id",table,file); + sprintf(sql,"select * from %s where filename='%s' and commented=0 order by filename,cat_metric desc,var_metric asc,id",table,file); res = SQLExecDirect(stmt,sql,SQL_NTS); if ((res != SQL_SUCCESS) && (res != SQL_SUCCESS_WITH_INFO)) { -- cgit v1.2.3