diff options
| author | seanbright <seanbright@f38db490-d61c-443f-a65b-d21fe96a405b> | 2008-06-29 13:11:55 +0000 |
|---|---|---|
| committer | seanbright <seanbright@f38db490-d61c-443f-a65b-d21fe96a405b> | 2008-06-29 13:11:55 +0000 |
| commit | 76942ba4d306c45270463cfb3b119f63a76036f8 (patch) | |
| tree | 64bd803a40e394386d6d3d25317bffa294c8b662 /cdr | |
| parent | 001a1d99682a109e55f1c1bac13b9528a19b86c7 (diff) | |
While we're at it, escape all the columns in our TDS queries as well. Double
quotes seems to be more standard than square brackets (Sybase and SQL Server
both support them).
git-svn-id: http://svn.digium.com/svn/asterisk/trunk@126312 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'cdr')
| -rw-r--r-- | cdr/cdr_tds.c | 38 |
1 files changed, 19 insertions, 19 deletions
diff --git a/cdr/cdr_tds.c b/cdr/cdr_tds.c index 2f17cac2d..928730898 100644 --- a/cdr/cdr_tds.c +++ b/cdr/cdr_tds.c @@ -136,25 +136,25 @@ static int tds_log(struct ast_cdr *cdr) } erc = dbfcmd(settings->dbproc, - "INSERT INTO %s " + "INSERT INTO \"%s\" " "(" - "accountcode, " - "src, " - "dst, " - "dcontext, " - "clid, " - "channel, " - "dstchannel, " - "lastapp, " - "lastdata, " - "start, " - "answer, " - "[end], " - "duration, " - "billsec, " - "disposition, " - "amaflags, " - "uniqueid" + "\"accountcode\", " + "\"src\", " + "\"dst\", " + "\"dcontext\", " + "\"clid\", " + "\"channel\", " + "\"dstchannel\", " + "\"lastapp\", " + "\"lastdata\", " + "\"start\", " + "\"answer\", " + "\"end\", " + "\"duration\", " + "\"billsec\", " + "\"disposition\", " + "\"amaflags\", " + "\"uniqueid\"" ") " "VALUES " "(" @@ -317,7 +317,7 @@ static int mssql_connect(void) goto failed; } - if (dbfcmd(settings->dbproc, "SELECT 1 FROM [%s]", settings->table) == FAIL) { + if (dbfcmd(settings->dbproc, "SELECT 1 FROM \"%s\"", settings->table) == FAIL) { ast_log(LOG_ERROR, "Unable to build query while verifying the existence of table '%s'\n", settings->table); goto failed; } |