Index: res/res_config_odbc.c =================================================================== RCS file: /usr/cvsroot/asterisk/res/res_config_odbc.c,v retrieving revision 1.7 diff -u -r1.7 res_config_odbc.c --- res/res_config_odbc.c 14 Jul 2004 13:57:15 -0000 1.7 +++ res/res_config_odbc.c 23 Aug 2004 19:31:43 -0000 @@ -96,7 +96,7 @@ 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 id, cat_metric, var_metric, commented, filename, category, var_name, var_val from %s where filename='%s' and commented=0 order by filename,cat_metric desc,category,var_metric asc,id", table, file); res = SQLExecDirect (stmt, sql, SQL_NTS); if ((res != SQL_SUCCESS) && (res != SQL_SUCCESS_WITH_INFO)) {