diff options
author | Tilghman Lesher <tilghman@meg.abyt.es> | 2010-03-05 04:37:36 +0000 |
---|---|---|
committer | Tilghman Lesher <tilghman@meg.abyt.es> | 2010-03-05 04:37:36 +0000 |
commit | 6d166a9af9a2ded74f8830daf485d430a88e9ff0 (patch) | |
tree | ec7f124518e72f5a69497c48eaa401ece356c2d7 /apps/app_voicemail.c | |
parent | 335558c5d14716987eb97bd97c8596651e31240b (diff) |
Missing quote in ODBC query.
(closes issue #16953)
Reported by: elguero
Patches:
app_voicemail-odbc-syntax-fix.diff uploaded by elguero (license 37)
git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@250913 65c4cc65-6c06-0410-ace0-fbb531ad65f3
Diffstat (limited to 'apps/app_voicemail.c')
-rw-r--r-- | apps/app_voicemail.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/apps/app_voicemail.c b/apps/app_voicemail.c index c146fe11c..b21c0e1c6 100644 --- a/apps/app_voicemail.c +++ b/apps/app_voicemail.c @@ -4973,7 +4973,7 @@ static int messagecount(const char *context, const char *mailbox, const char *fo obj = ast_odbc_request_obj(odbc_database, 0); if (obj) { if (!strcmp(folder, "INBOX")) { - snprintf(sql, sizeof(sql), "SELECT COUNT(*) FROM %s WHERE dir = '%s%s/%s/INBOX' OR dir = '%s%s/%s/Urgent", odbc_table, VM_SPOOL_DIR, context, mailbox, VM_SPOOL_DIR, context, mailbox); + snprintf(sql, sizeof(sql), "SELECT COUNT(*) FROM %s WHERE dir = '%s%s/%s/INBOX' OR dir = '%s%s/%s/Urgent'", odbc_table, VM_SPOOL_DIR, context, mailbox, VM_SPOOL_DIR, context, mailbox); } else { snprintf(sql, sizeof(sql), "SELECT COUNT(*) FROM %s WHERE dir = '%s%s/%s/%s'", odbc_table, VM_SPOOL_DIR, context, mailbox, folder); } |