diff options
| author | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2010-03-05 04:37:36 +0000 |
|---|---|---|
| committer | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2010-03-05 04:37:36 +0000 |
| commit | f8f8e147c933719d1c24c8c4d97cb4b542768078 (patch) | |
| tree | ec7f124518e72f5a69497c48eaa401ece356c2d7 /apps/app_voicemail.c | |
| parent | a477714ebc1acf9d6dc1e2e6d2085a450ade0394 (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: http://svn.digium.com/svn/asterisk/trunk@250913 f38db490-d61c-443f-a65b-d21fe96a405b
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); } |